All Questions
100
questions
1
vote
0
answers
1k
views
excel - how to count number of names in a column, name is specified in a cell
I have two worksheets, "Clients 2014" and "Receipts 2014".
The receipts have client names for each row (each row is a receipt).
The search key is in the "Clients 2014" worksheet.
I want to ...
1
vote
1
answer
2k
views
How do I count multiple words available in sentences and multiple rows (countif, search)?
here is screenshot for the sheet.
https://flic.kr/p/qZb8ot
in column A there are some senteces list below:
A2. T-shirts, Varsity
A3. T-shirts, Sticker, Mug
A4. T-shirts
A5. T-shirts, Pin, ...
1
vote
1
answer
758
views
Advanced data consolidation in Excel
I need to Combine/Consolidate Data dynamically between over 20 separate Excel workbooks. The Column names and their relative position at the top row are the same. The positioning of each word under ...
0
votes
3
answers
30k
views
Excel formula to count when value changes?
I have an Excel conundrum I can't seem to crack.
In Column A I have a long list of counties, and each of those counties is a member of a larger group of counties that pertain to a particular funding ...
0
votes
9
answers
19k
views
Excel COUNTIF Slow
I'm having an odd issue in excel that I haven't run into before. I have an excel sheet that I'm attempting to pull some specific records from, requiring that I know of duplicates. I am using a COUNTIF ...
1
vote
2
answers
4k
views
Excel count all rows that contain certain values for certain fields
I have a sheet with a couple hundred rows. Each row has an 'owner' and a pass/fail field. I am making a second sheet that has statistics for the users. So for each user it will count the number of ...
0
votes
1
answer
509
views
Count instances of a letter in a row if a certain cell in that row contains a specified date
I have a spreadsheet containing a column of dates (week commencing) with columns of data to the right of it, and a conditional formatting rule that highlights this week's row based on the date.
I ...
3
votes
3
answers
15k
views
Include an OR condition in a COUNTIF?
This question has been asked before and the answer always seems to be to add together two COUNTIFs. This is fine for most applications, but won't work for me.
I have a column that can contain 0, 1 or ...
1
vote
0
answers
141
views
Custom function COUNTIFUNIQUES in Excel [duplicate]
Possible Duplicate:
Excel: how to count number of distinct values in a range?
I would like to create a custom function COUNTIFUNIQUES that extends the functionality of COUNTIFS.
Here is an ...
5
votes
2
answers
8k
views
Excel: Counting number of MAX values in a range
I am using Excel 2003 (version limited due to corporate policy) to keep a score sheet:
A B C D
1 Round | Rita | Sue | Bob
------+------+-----+-----
2 1 | 5 | 3 | 4
3 ...