Thread: [Solved] How do I get the Max date
View Single Post
 
Old 03-14-2022, 11:23 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
Into field C2 enter the formula
=((COUNTIFS($A$2:$A$58,$A2,$B$2:$B$58,">" & $B2)+1)=1)*(COUNTIFS($A$2:$A2,$A2,$B$2:$B2,$B2)=1)[/CODE]
, and copy down.

And sorting is not essential - the formula returns 1 for 1st record with latest date it finds for given item.
Reply With Quote