Forum Discussion
Solved
Unique Count of Filtered Excel Workbook
Hi I hope that someone out there can assist me. I have a commercial invoice in excel for some of our clients, which is filterable by area. The problem I am sitting with is that I need to give t...
You can use this complicated formula:
=SUM(IF(FREQUENCY(IF(SUBTOTAL(3,OFFSET(A9,ROW(A9:A385)-ROW(A9),,1)), IF(A9:A385>"",MATCH("~"&A9:A385,A9:A385&"",0))),ROW(A9:A385)-ROW(A9)+1),1))
A9:A385 is the range in which you want to count unique values, and A9 is the first cell in this range.
You can use this complicated formula:
=SUM(IF(FREQUENCY(IF(SUBTOTAL(3,OFFSET(A9,ROW(A9:A385)-ROW(A9),,1)), IF(A9:A385>"",MATCH("~"&A9:A385,A9:A385&"",0))),ROW(A9:A385)-ROW(A9)+1),1))
A9:A385 is the range in which you want to count unique values, and A9 is the first cell in this range.
- Thank you so much Hans, this works perfectly.
