Dear Members,
very nice to meet u, very long back i came to ur platform. I have a sheet which contains the name of 4000 names containing 4 columns, but i have to search the duplicate names of those surname and name as same. Pl. suggest any formula. I shall be very grateful to you.
Regards,
Krishna
Hi
It's a very general question the one that you do!! SUMPRODUCT should do this but we need more details and even better a small sample workbook.
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.
Dear Sir,
Pl. have a look at the following sample data as Sl.No. 3 & 6 are duplicate. I have to find out the date like wise.
sur name name Address Sl.No
MURALA RAGHAVA PHANI RAJ SEKHAR 1-36 1
NUNNA BHAGYALAKSHMI 2 -41 2
MURARI KISHORE KUMAR 1‐MIG ‐288 3
CHITTIBOMMA CHINNAMMA 1‐MIG 288 4
YADAVALLI PANDURANGARAO 11 5
MURARI KISHORE KUMAR MIG - 21 6
Regards,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks