Hi there guys,
I have attached a sample of what im trying to do here.
A2:A10 i have items, B2:B10 they can selected "yes" or "no" and C2:C10 the values
what i would like is, is "yes" was selected, i would like the item name added to a list. so basically:
=IF(A2:A10="YES",A2:A10)
and then i can just add the value to each item later (that part im fine with)
but i need to remove duplicates and obv have this carried throughout the cells.
any help??? please
Bookmarks