Forum Discussion
Counting unique posts in a table with multiple conditions
Hi Im trying to calculate number of rows in a table that fulfil multiple conditions using the COUNTIFS function. My problem is that I only want to count rows holding unique values in one of the colu...
Coung - Not really, I found that part myself and it seems a bit too simplified to really help me address my issue.
Sergei – Im using Excel365. FILTER and UNIQUE are available functions (even if they are called FILTER and UNIK in my swedish version). Must try those, haven’t used those formula fun
JMB17 – Thanks for the shared formulas, need to study them closer to understand wh
In general, I think I’ll try first with the FILTER/UNIQUE functions, it’s always nice when things can be solved as easy as possible.
Thank you all very much!
For now, that is. We’ll see if I need more support later… 😊
This may be helpful. I imagine you would wrap it with count or counta, but I'm not sure what filter returns by default when there are no matches (error, blank, zero)? So, you may have to play with that (filter does have an optional argument to specify what to return if no matches).
https://exceljet.net/formula/unique-values-with-multiple-criteria
https://exceljet.net/formula/unique-values-with-multiple-criteria