LinkBack URL
About LinkBacks
Hey guys
I hope your well
i need helping writing/creating a formula, which will show me what cells are duplicates
For eg row 38, is a duplicate of row 39
please find attached file
Looking forward to your resposne
Hey guys
I hope your well
i need helping writing/creating a formula, which will show me what cells are duplicates
For eg row 38, is a duplicate of row 39
please find attached file
Looking forward to your resposne
I don't see 38 en 39 are duplicated.
nr 37 is duplicated.
See the attachment.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi
Comparing with all three columns? Or just column A?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Well row 38 is duplicated to row 39
row 38 column c has the number 8259772,
row 39 column c has the number 000000008259772,
The last 7 digits are an exact match,. which indicates that its a duplicate
---------- Post added at 01:27 PM ---------- Previous post was at 01:26 PM ----------
Column a, shouldnt be included in the search
it should only focus on column c and d
column c and need there own look up, as there is no comparision between the 2 numbers
In my earlier post i meant column D.
in row 38 column D i have 8.78223E+11 (als with a dot)
in row 39 column D i have 878223122887
then it will be this one.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks