Katherine1
New Member
- Joined
- Oct 4, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
The document I have is several thousand rows long and by about 130 columns. I need to determine the latest load date for each Item number.
Based on the item # in Column B, I would like to highlight the current Item #, (Column C; Y = Yes) with the latest Load date in Column D. In several cases, an item # may have multiple load dates that appear to be current. Items have varying numbers of rows so multiple rows will need to be highlighted for each item.
Thank you in advance for your help!
Katherine
Based on the item # in Column B, I would like to highlight the current Item #, (Column C; Y = Yes) with the latest Load date in Column D. In several cases, an item # may have multiple load dates that appear to be current. Items have varying numbers of rows so multiple rows will need to be highlighted for each item.
Thank you in advance for your help!
Katherine