Need help with duplcates please!!
Hi, Im having trouble with duplcate entrys in a very large spreadsheet. Some customers details are duplcated in spreadsheet, if so they are always listed in adjacent rows directly below. Therefore I need to search in one column and delete the entire row if the cell matches the cell directly above it. any help would be much appreciated, Many thanks, Andrew -- Shandy720 ------------------------------------------------------------------------ Shandy720's Profile: http://www.excelforum.com/member.php...o&userid=26230 View this thread: http://www.excelforum.com/showthread...hreadid=565927 |
Need help with duplcates please!!
Hi Shandy720, Try this it will find duplicates Put this formula in B1 =IF(A1=A2,"duplicate","") and copied this down to the end - this says if A1 is the same as A2 mark it as "duplicate" otherwise put "blank" Alter cell ref to suit oldchippy:) -- oldchippy ------------------------------------------------------------------------ oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907 View this thread: http://www.excelforum.com/showthread...hreadid=565927 |
Need help with duplcates please!!
If column A contains a list of names, starting at A1, you can use the
following formulae in B1 and copy to remaining column B to filter out duplicates: Col. A Col. B Miller =IF(COUNTIF(A:A,A1)1,"Duplicate?","") Smith =IF(COUNTIF(A:A,A2)1,"Duplicate?","") Herbert =IF(COUNTIF(A:A,A3)1,"Duplicate?","") Mayer =IF(COUNTIF(A:A,A4)1,"Duplicate?","") Miller =IF(COUNTIF(A:A,A5)1,"Duplicate?","") Slayman =IF(COUNTIF(A:A,A6)1,"Duplicate?","") etc. The result will be a "Duplicate? next to every identical Miller. "Shandy720" wrote: Hi, Im having trouble with duplcate entrys in a very large spreadsheet. Some customers details are duplcated in spreadsheet, if so they are always listed in adjacent rows directly below. Therefore I need to search in one column and delete the entire row if the cell matches the cell directly above it. any help would be much appreciated, Many thanks, Andrew -- Shandy720 ------------------------------------------------------------------------ Shandy720's Profile: http://www.excelforum.com/member.php...o&userid=26230 View this thread: http://www.excelforum.com/showthread...hreadid=565927 |
Need help with duplcates please!!
Thanks a lot both of you for helping me out and so quickly!!! old chippy - cheers really simple and works perfectly - that was exactly what i need! Have a good weekend! -- Shandy720 ------------------------------------------------------------------------ Shandy720's Profile: http://www.excelforum.com/member.php...o&userid=26230 View this thread: http://www.excelforum.com/showthread...hreadid=565927 |
All times are GMT +1. The time now is 05:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com