Hello All. My first Post here. I've searched the KB but I couldn't find what I was looking for. If someone has seen my type of issue in the KB, if you would, please let me know where.
Otherwise --
Objective: 1) Identify multiple rows (could be 2 rows or 3 rows...) that contains identical data in specific cells (ID #). 2) Compare data (from all identified rows) in specific cells that is different. 3) Eliminate the unwanted rows.
Data: I have a worksheet that contains Names, ID #'s, Descriptions, dates, status... and so on. I could have the same person (meaning: same name, same ID #, same date) but their date and/or status may differ. I would want to keep the most current row that has a status of "Successful" and remove the other records of this person from the file.
<tbody>
</tbody>
Using the example above, I have bob 3 times (3 rows). My target is that he is "Successful" but I don't want the last instance or last row, I need the most current date. Also, I would need to do the same check for each unique person (for Karen and others as well). I have over 3000 unique people, so potentially I could have 9000 +- total rows on the worksheet to sort through. I have to do this check every week, so if I could automate this as a Macro or as a template, that would be great! I could probably figure out how to read in the file in VBA, but it's how to identify the row(s) that I need, that's what I need help with.
Environment: Windows10 Pro., Office 365
Any assistance would be greatly appreciated.
Otherwise --
Objective: 1) Identify multiple rows (could be 2 rows or 3 rows...) that contains identical data in specific cells (ID #). 2) Compare data (from all identified rows) in specific cells that is different. 3) Eliminate the unwanted rows.
Data: I have a worksheet that contains Names, ID #'s, Descriptions, dates, status... and so on. I could have the same person (meaning: same name, same ID #, same date) but their date and/or status may differ. I would want to keep the most current row that has a status of "Successful" and remove the other records of this person from the file.
Name | ID # | Status | Date |
bob jones | 123456 | Not Evaluated | 05/01/2016 |
bob jones | 123456 | Successful | 05/02/2016 |
bob jones | 123456 | Successful | 05/01/2016 |
Karen james | 654321 | Not Evaluated | 02/05/2017 |
Karen james | 654321 | Unsuccessful | 03/06/2017 |
<tbody>
</tbody>
Using the example above, I have bob 3 times (3 rows). My target is that he is "Successful" but I don't want the last instance or last row, I need the most current date. Also, I would need to do the same check for each unique person (for Karen and others as well). I have over 3000 unique people, so potentially I could have 9000 +- total rows on the worksheet to sort through. I have to do this check every week, so if I could automate this as a Macro or as a template, that would be great! I could probably figure out how to read in the file in VBA, but it's how to identify the row(s) that I need, that's what I need help with.
Environment: Windows10 Pro., Office 365
Any assistance would be greatly appreciated.