Remove duplicates, filter by smallest value

Pete

D1:

Please Login or Register  to view this content.

This is array entered (ctrl, shift, enter)

Copy down to D7.

Then select A1, filter, autofilter, Column D select TRUE.


HTH

rylo

hi,
thanks for your help.
i've tested it but the only problem is when i do a TRUE filter i don't see VVV in the output. (both VVV rows are false) any ideas why?

thanks!

Hi

Have you array entered the formula? Edit the formula, then hold down the ctrl and shift keys, then press enter. You should find the entire formula is contained in {} if it has entered properly.

rylo