Hi,
I have a list of items with of which some are repeated with identical UID's, I can easily identify the dulicates (as shown in column 'D') but would like to sort the enclosed example so that there is just 1 of each UID, as identified in column 'E'
Any help apprecaited
Hi there. Try this
Formula:
Please Login or Register to view this content.
this is an array formula and must be set using CTRL + SHIFT + ENTER and not just enter. Excel will add the curly brackets. If they don't appear, hit F2 and try again.
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
Sorry, I forgot to attach the file...
Hi Glenn,
Thanks for the reply and I can see that this formula lists all the unique UID's, however is it possible to either:-
1. Add a marker against the unique UID as shown with the xx in field 'E'
or
2. Edit the formula to copy all the row data against each unique UID eg the data to the left and right of C006
Carpet C006 Duplicate
Garry
is this what you meant at 2)?
Perfect, just what I was looking for, many thanks
G
You're welcome. To keep things tidy, can you mark the thread as solved and (preferably) click the Add Reputation button at the foot of this post?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks