Hi all,
I need to analyse the unique values within a range while neglecting zeros and blanks, but only from a certain category ("BOTTOMS" & "KNITS"). So far I have only managed to return the unique values but including 0. For some reason it does not ignore 0?? See sample file attached...
Bookmarks