Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut Duplicate Records based on criteria
Hello All
I have a set of records with five columns viz., Name Address City State Date Status All the columns are self-explanatory. The Status column has one of values (approximate, confirmed, estimates). The program has to find duplicate records based on the condition that Name Address City and State are same. Once, the duplicate records are found, the program has to check for Status of the record. If the status is confirmed, then the program should cut the other duplicate records and paste them in another sheet. If none of the records have Status as confirmed, then the next criteria is date. The program has to check for the latest date and cut and paste other records in another sheet. If more than one record has status as confirmed, then apply the same above rule. I know its complex. Thanks in advance Shiva |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing duplicate records based off of date | Excel Worksheet Functions | |||
Count Unique records based on the Criteria in another colum | Excel Worksheet Functions | |||
Count Unique records based on the Criteria in another colum | Excel Worksheet Functions | |||
In Excel, how do I get rid of duplicate records? Based on text r. | Excel Discussion (Misc queries) | |||
write records to another worksheet based on criteria | Excel Programming |