PDA

View Full Version : Single value criterion



marreco
12-14-2011, 05:43 PM
Hi...

I would like you to help us to know how many have unique values ​​in a column based on certain criteria.

See Annex ..

Thank you!


cross-posting
http://www.thecodecage.com/forumz/pt/microsoft-excel-worksheet-functions/

marreco
12-14-2011, 06:09 PM
Hi...
I managed to solve.

look

= SUM (IF (FREQUENCY (IF (A2: A19 = zin, MATCH (C2: C19, C2: C19, 0)), ROW (C2: C19)-ROW ($ C $ 2) +1), 1)) + CTRL + SHIFT + ENTER

Thanks

Simon Lloyd
12-15-2011, 01:22 AM
you could also use Advanced filter>filter in place and the click the checkbox for show unique values, that way it's one less volatile formula to worry about :)

marreco
12-15-2011, 01:47 AM
Thank you for the brilliant tip I had not really thought about it.
Thank you very much