Forum Discussion
Solved
Which formula should I use?
Hi all,
Which formula should I use to count the number of suppliers excluding duplicates and using the date filters highlighted in blue?
The result for each example should be the numbers highlighted in yellow.
Thank you.
Shouldn't the 2nd example return 3? The non-zero suppliers are AAA, BBB and CCC.
In E5:
=COUNTA(UNIQUE(FILTER($I$9:$I$24,($H$9:$H$24>=E2)*($H$9:$H$24<=E3)*($I$9:$I$24<>0))))
Copy/paste to H5 and K5
2 Replies
Shouldn't the 2nd example return 3? The non-zero suppliers are AAA, BBB and CCC.
In E5:
=COUNTA(UNIQUE(FILTER($I$9:$I$24,($H$9:$H$24>=E2)*($H$9:$H$24<=E3)*($I$9:$I$24<>0))))
Copy/paste to H5 and K5
- Thank you so much! This is exactly what I need.
Correct, 2nd example result is 3. Sorry, my mistake 🙂
