Single value criterion

[marreco]

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...eet-functions/

[marreco]

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]

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]

Thank you for the brilliant tip I had not really thought about it.
Thank you very much