mcmullenrich
New Member
- Joined
- Apr 14, 2009
- Messages
- 20
I have a spreadsheet with about 8,000 lines with patient data. It is sorted by Patient Name (column B), then by Visit Date (column G). I need to delete all rows where a single patient does not have any 2013 dates and keep all rows where a patient has at least one 2013 date. For example:
Joe Smith 2/1/2012
Joe Smith 4/1/2012
I need to delete both rows. But if
Steve Johnson 12/1/2012
Steve Johnson 1/31/2013
I need to keep both rows.
I have found some answers about deleting entire rows based on one criteria like a cell value, but nothing addresses this exactly.
Any help would be greatly appreciated.
Joe Smith 2/1/2012
Joe Smith 4/1/2012
I need to delete both rows. But if
Steve Johnson 12/1/2012
Steve Johnson 1/31/2013
I need to keep both rows.
I have found some answers about deleting entire rows based on one criteria like a cell value, but nothing addresses this exactly.
Any help would be greatly appreciated.