Thread: [Solved] How do I get the Max date
View Single Post
 
Old 03-14-2022, 12:59 PM
wheddingsjr wheddingsjr is offline Windows 7 64bit Office 2016
Advanced Beginner
  
Join Date: Mar 2017
Posts: 76
wheddingsjr is on a distinguished road
Default How do I get the Max date
Hi all

I have data that has items with the same codes but different dates. I have sorted the data by item number and date descending). I want to mark the first item with the most recent date as 1 and all of the other like items be marked as 0 (see attached example). I tried a few different formulas but none of them worked. Any suggestions would be appreciated.

Thanks
Attached Files
File Type: xlsx Book2.xlsx (10.0 KB, 12 views)
Reply With Quote