hi
how to see the total amount of unique values only
name|value
A 1
A 3
B 4
C 2
B 3
C 2
total amount of unique values
name |value
A 4
B 7
C 4
thanks
hi
how to see the total amount of unique values only
name|value
A 1
A 3
B 4
C 2
B 3
C 2
total amount of unique values
name |value
A 4
B 7
C 4
thanks
Last edited by herukuncahyono; 12-10-2014 at 05:21 AM.
A16
=INDEX($A$2:$A$7, MATCH(0, COUNTIF($A$15:A15, $A$2:$A$7), 0))
enter with Ctrl-Shift-Enter
and B16
=SUMIF($A$2:$A$7,A16,$B$2:$B$7)
copy both down
Have you tried a pivot table with the Name and the sum of the value as the two criteria?
Happy with my advice? Click on the * reputation button below
Hi Alan Y, your answer is more than enough
Crooza, I have not tried that, it seems a new thing for me..
thanks for you both
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks