Forum Discussion
Checking data in two rows, and if the same then take the latest time and date form another row
I have a question I am looking for a formula of VBA for the following comparisation. I want to filter or mark only the latest date and time in column G, from which data in column C a...
=IF(G2=LARGE(IF(($C$2:$C$11=C2)*($D$2:$D$11=D2),$G$2:$G$11),1),"X","")You can try this formula in order to mark the row with the highest value in column G. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.