Hi,
With reference to http://www.excelforum.com/excel-gene...ml#post2395095, how can I count a row of items that is not repeated? Is there a function to do this?
Example,
A1 = Apple
B1 = Apple
C1 = Orange
D1 = Durian
E1 = Orange
Total Fruits = 3
Hi,
With reference to http://www.excelforum.com/excel-gene...ml#post2395095, how can I count a row of items that is not repeated? Is there a function to do this?
Example,
A1 = Apple
B1 = Apple
C1 = Orange
D1 = Durian
E1 = Orange
Total Fruits = 3
Last edited by Lewis Koh; 04-24-2011 at 11:05 PM.
Hi, I got it. Pls ignore this post. Thanks.
=SUMPRODUCT((A1:E1<>"")/COUNTIF(A1:E1,A1:E1&""))
Hi Lewis,
See the attached with a helper column and the answer at the top.
You could also do a Advanced Filter using the Unique check box.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks