Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Duplicate cell search
Hi,
I manage a computer repair centre, where over a 1 week period we may service 200 units. I need to serach a spread sheet for repeat offenders, units that come in more than once over different periods using their unique serial numbers. Once I've isolated these units in want delete all the single rows leaving me with only the duplicated serial numbers. Brenden |
#2
|
|||
|
|||
Chip Pearson has lots of ways to work with duplicates at:
http://www.cpearson.com/excel/duplicat.htm Brendenw9 wrote: Hi, I manage a computer repair centre, where over a 1 week period we may service 200 units. I need to serach a spread sheet for repeat offenders, units that come in more than once over different periods using their unique serial numbers. Once I've isolated these units in want delete all the single rows leaving me with only the duplicated serial numbers. Brenden -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I search for more than one text character in a cell? | Excel Worksheet Functions | |||
Function syntax to compare cell contents | Excel Worksheet Functions | |||
Cell addressing using the content of another cell. | Excel Worksheet Functions | |||
Cell content elimination; duplicate | Excel Worksheet Functions | |||
=IF logical test to search only part of a cell | Excel Worksheet Functions |