everblazing
Board Regular
- Joined
- Sep 18, 2015
- Messages
- 156
Hi all
I'd appreciate some help in being able to delete all rows in my sheet where below condition doesn't meet or retain rows if blow condition meets.
for every cell in column B that has the same name
column F "Date and Time Completed" has the latest time and date, Format of time and date is (20/06/2019 2:02:41 AM) without the parenthesis & Column I "Plan FY" is equal to "Last Review"
I'm not sure what is he best way to tackle this. I would appreciate any suggestions.
Regards
Lucas
I'd appreciate some help in being able to delete all rows in my sheet where below condition doesn't meet or retain rows if blow condition meets.
for every cell in column B that has the same name
column F "Date and Time Completed" has the latest time and date, Format of time and date is (20/06/2019 2:02:41 AM) without the parenthesis & Column I "Plan FY" is equal to "Last Review"
I'm not sure what is he best way to tackle this. I would appreciate any suggestions.
Regards
Lucas