How do you duplicate information if it matches a criteria
Please could any one help solve this problem as i cant figure it out.
I have a list of names in C1:C200 and in B1:B200 i have put "Y" if the people match a criteria i wanted.
Is there a way i can reproduce the list of names from C1:C200 to a different area with just the names that have "Y" next to them. i.e a shorter list?
Any help would be much appreciated.
I do hope this makes sense as its my first thread.
Regards
Phil
|