Hi All,
I've attached an example sheet, column I contains a list of items with multiple duplications, column M has that list with all the duplicate removed. I'm looking for a formula (probably array!) to put in column M so that every time a new item is placed in column I it appears once in the list on column M.
Let me know if I'm being unclear! Thanks
Hi Dave,
Cell M2 formula would be:
Formula:
Please Login or Register to view this content.
and press CTRL +SHIFT+ ENTER
Cheers
Lex
If you'd prefer them in alphabetical order, this ARRAY- FORMULA (CTRL Shift Enter) will do it. I also used a Named Range (List) to kep the formula a bit simpler, but which will expand automatically as you add items to the list. See CTRL F3 fr the formula to set it up.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh
Thank you!
You're welcome...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks