I have a range of names "AQ3:AT37". Their are duplicate names in the range and while their are no gaps in each column list, each column is not a full 35 names long, they all vary around 20 some names each. Starting at "AU3" I want to produce a single column list with no duplicates.
Thanks.
Jim O
Last edited by JO505; 01-09-2012 at 09:29 PM.
Arrayformula; Ctrl+Shift+Enter, not only Enter.
Please Login or Register to view this content.
Kind regards, Harry.
Harry,
Thank you very much for the response. That is what I was looking for.
JIm O
Jim,
For Excel 2007 or higher.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks