non-array MAX IF ??? to find most recent date with criteria

Hi peeps. Thanks in advance for your expertise. I'm stumped.

So I have stock takes from different sites on different days and different times. I want a column to return "true" if a stock take is the latest of that day.

I've tried a few things, so in the below screengrabs i now have various helper columns, most of which i suspect are unnecessary...

I had thought row 7 would be most useful; essentially a unique ID to check (site code+datevalue) and a time decimal. Essentially, what is largest remainder of all entries beginning with [row5]

the formula for row 8:8 is the one I'm struggling with. It should return blanks in all but E8, and H8.
N.B. the latest entered (ie right-most column) is not necessarily the latest (ie column E's stock take is more recent than the later entered column F)

1.JPG

2.JPG

Paste the following formula in B11, copy across to G11 and see if it does what you want:

Formula:

Please Login or Register  to view this content.

Let me know if you have any questions.

You're welcome, thank you for the feedback and for marking the thread 'Solved'. To be honest I had just seen the ...($B3:$G3&$B4:$G4>B3&B4)... notation used to solve a query a couple of days back. Something, Divine Providence perhaps, called it to mind when I looked at the spreadsheet that you uploaded. I tested with your file, which is one of the benefits of attaching a file to a query, and it worked. SUMPRODUCT is a function that can handle array arguments, so it isn't necessary to activate with CSE, or at least in this case. A good way to see what the formula is doing is to select D11 and run Evaluate Formula from the Formula tab. As to the processor heavy part, I don't know the answer to that one. I hope that you have a blessed day.