return TXT Values and remove duplicates?
1 BOB ___ JANE
2 BOB ___JANE
3 BOB ___MICHELLE
4 BOB ____MICHELLE
5 BOB ___MICHELLE
6 BOB ___ Tracy
7 BOB ____Tracy
8 BOB ____SCOTT
How can I do a lookup BOB in column A of SHEET 1, and return only the unique names of Column B on Sheet 1? (A1 will come prepopulated with BOB, I just need to list the Names below). Can you do a formula in Cells A2:A5 that will VLOOKUP A1 and return only the unique names in the entire B1 Column beside the Name BOB in Column A?
So, i would like to see the result be (No duplicate names):
Last edited by fordzilla; 09-29-2011 at 06:28 PM.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1