Hi,
In columns A to C I have a series of names, with many in any column being included in the other two columns.
In column E I would like to create using a formula a list the contains a single instance of each name in columns A to C.
Can someone please suggest a formula to achieve this.
Thanks!
Last edited by andrewc; 11-24-2014 at 12:13 PM.
Can you upload a sample workbook to see what you are working with?
Spread the love, add to the Rep
"None of us are as smart as all of us."
Do you mean something like this?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks