how to find unique values in an entire column

younker1983 · Aug 10, 2006, 04:43 AM

hi all

tell me how can i findout the unique values in an entire coloumn.
for example i have 3 coloumn in an sheet.

Name Prod. value
a 24 100
b 26 240
a 33 120
a 21 200
c 26 240
b 33 120
d 24 100

from this one i want to knpow that How many persons we r having. (there are only 4 persons in this example i.E. a,b,c and d.) but total rows are 7.

tell me how can i do this.

From
Manu Verma

colbtech · Aug 13, 2006, 11:42 PM

Any cell you care to have the totals in.

Taking the example above:-
H10:J16 are the cells that will be evaluated
H10 contains the value that we are going to check
I10:I16 are the values to add if the corresponding column (H) contains the value we are checking for.

I've attached a zipped file that might help



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!