Hello. I have a column of dates and then another column to the left with statuses. I want to count the number of UNIQUE dates ONLY if the status is "paid". However, I only want the unique count. So if there are five of the same dates, and five status of paid it should only count this as 1. How can I do this? Spreadsheet attached. Thanks.
Try this
Formula:
Please Login or Register to view this content.
Or this
Formula:Please Login or Register to view this content.
Last edited by AlKey; 07-07-2016 at 07:54 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
with a helpcolumn and a pivot table.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hey AlKey this is great. Thanks. Can you describe the logic for these things? I tried to walk through but it was difficult.
Also, it doesn't seem to work if there are blanks (for status). What do I do in those cases? Thanks.
I've attached the "real" spreadsheet and your formulas don't work
Thanks for your help.
Last edited by stephme55; 07-07-2016 at 05:48 PM.
@ Oelder. That is great!! Thanks. What about if I have more values other than just "no"?
@ Oelder. That formula though gets really slow when you have lots of rows (which I do). Yeah, my spreadsheet freezes up when I try your method (I have 80,000 rows). I'll try oeldere's again.
Edit, actually even your formulas get bogged down when there are more than 10000 rows.
Last edited by stephme55; 07-07-2016 at 06:27 PM.
copy the data
data => remove duplicates on column C (help)
after that a pivot table
See the attached file.
Another way. It has to be array entered.If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.Formula:Please Login or Register to view this content.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks