Calculating a sum of certain data based on other dats
I am trying to see how a mailing affects the response rate of customers over the next week after it is sent. I want to do some sort of SUM IF fucntion but I …
I am trying to see how a mailing affects the response rate of customers over the next week after it is sent. I want to do some sort of SUM IF fucntion but I …
I have a timetable for my school. In the first column are the staff. Across the rows are the days of the week. The content of the table is …
I have a Workbook with 9 SheetsEach Sheet has 4 columns of data:Column A: Login (Time Stamp of User login)Column B: User (Name)Column C: Team (Department …
Ive got data sorted like this (see below), if I select column by column and then go “Delete duplicates” then it works fine, however if I select …
lets say i have : start date 1 and end date 1 , start date 2 and end date 2 , start date 3 and end date 3. I want to know how many times the date …
Hi, I’m wondering if there is a way to use the Count function while assigning different values to different texts. More specifically, I’m trying to …
Hi I need some help. I want to put in one column for example 5 times letter X (in two rows) X X X X X X X X X X and I want to have Sum of them (or count) to …
Hi, Is it possible to highlight cells a specified number of cells away from a reference cell? the specified number of cells away would be the value …
I have an excel map two layers. One layer contains points (defined by longitude and latitude) and another layer containing polygons (shapefile format). Is …
Hi, Please how to I count the number of yes in coloumn are the match dog or car in column b? By:
I have a list of data, exported to excel, which has ‘TRUE’ or ‘FALSE’ in a column, based on if they checked a box on a previous form. …
Greetings, I got a question about a function. My skills in VBA isn’t that great, so sorry. But, what I want is a function that will check e.g. cell L5 …
We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.