Checking Cell for Duplicate Data, Same Row, Different Columns
I have exported data to a spreadsheet that has multiple names and phone numbers in each row. Can someone help me with a function that will allow me to:
1. Check one of the phone numbers (Cell B2) against all the others in the row for duplicates (Cells E2,F2,G2,I2,J2).
2. Insert "Dup" or "No Dup" in a new cell.
This will allow me to filter out the "Dups".
This link will provide access to the screenshot, which describes the above: http://screencast.com/t/MKZ2K8QY6
Thank you for your assistance!!!
Last edited by aallen5642; 12-21-2011 at 05:20 PM. Reason: SOLVED
It will be better if you attach the file than providing us the link.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
hi aallen5642, assuming:
phone numbers to check are in the range: C2:J2
formula for K2 and drag down
Please Login or Register to view this content.
arlu1201 & watersev,
Thank you both for your inputs. Arlu1201, I have been unsuccessful at attaching the image to the thread. Watersev, the function provided didn't work.
Let me see if I can explain it a little better. If you look at the image, http://screencast.com/t/MKZ2K8QY6, cell B2 is the cell I want to compare to cells E2,F2,G2,I2 & J2. I want to see if B2 is duplicated in any of those other cells, if not I would like C2 to populate with "No Dup"; if so I would like C2 to populate with "Dup".
Thanks again for all of the assistance!
it did not work because it should be with coma, formula for C2:
Please Login or Register to view this content.
Watersev, thank you for hanging in there with me! That comma made the difference!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks