Hello Friends
Excel Version : 2010
Attached File name : <Eliminating duplicates.xlsx>
I want to eliminate the duplicates and plot without duplicate in the yellow cells. Any suggestions invited.
thanks in advance
thilag
Hello Friends
Excel Version : 2010
Attached File name : <Eliminating duplicates.xlsx>
I want to eliminate the duplicates and plot without duplicate in the yellow cells. Any suggestions invited.
thanks in advance
thilag
=iferror(index(a$2:a$11,match(0,index(countif(b$1:b1,a$2:a$11),0),0)),"")
try this formula
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
As per your sample sheet. Try this......
In B2
and copy down until you get blanks.Please Login or Register to view this content.
In E2
and copy down until you get blanks.Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Any problem in using excel built-in duplicate remover? Data tab > Data Tools > Remove Duplicates...
________________________________________________________
If your problem is solved, update the thread as SOLVED: Go to the top of the first post-Select Thread Tools-Select Mark thread as Solved OR - Go to the first post - Click edit- Click Advance- Just below the word "Title:" you will see a dropdown with the word No prefix.- Change to Solve- Click Save.
Show your gratitude to the person who helped you solving your problem by clicking on star button at the bottom of such post.
Hello nflsales, Hello sktneer, Hello haripopuri
thanks for all of your immediate reply.
Both of your formulas helped me lot. While generating reports `Data tab > Data Tools > Remove Duplicates' this option will not help, this option will help when we vcheck the results generated by the formulas.
thanks again
thilag
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks