Find Max and lookup previous non-blank date

[Sifuedition]

Excel help.png

I want to find the date of my max score in a log I am making.
Column A is the Date. I don't want to unnecessarily repeat it. I just want to Ctrl+; to dump it in at the start.
Column B is individual scores, but, what I am tracking is the combined score of the last 10 innings.
Column C is a running list of the last 10.
I'm thinking I should be able to use Max(C:C) to find the high score, and use that in an xlookup to find the date I achieved that score, but, I'm finding the formula to look for the previous non-blank field to be elusive. Any help is greatly appreciated.

[alansidman]

Please read the yellow banner at the top of this page on how to attach a file.

[Sifuedition]

The actual xlsx

[Sifuedition]

Please read the yellow banner at the top of this page on how to attach a file.

After attaching the image, I could not get it to let me attach the spreadsheet also, so I had to make it a separate post.

[Sifuedition]

Well, this has been really useful.

[alansidman]

Holiday Weekend in US. All volunteers here. Patience is what is needed when posting here as when you are awake, many others around the world are sleeping. Also, maybe you have not explained yourself clearly enough for others to dip a toe into the waters. Want to try and expand with examples using your uploaded data.

[Sifuedition]

The thread has been open for a week and contains both a screenshot and the .xlsx. I do understand it's all volunteers and there may not even be a solution for what I'm trying to do. There are 97 views with no comments. I'm not attempting to "insult" anyone, because there has been zero interaction to even judge, which was the frustration I expressed.

As per my screenshot, each day I practice, I place the date in column A for the first score on that date. Max(C:C) will show me my high score. I am trying to use something like an xlookup to find the date associated with that score. However, the date will not necessarily be on the same row, since I am only placing it in column A once for that date.

If it helps to see my intent, I will gladly fill in some "dummy" data to illustrate my question better. Just let me know if that will help. Thank you for at least responding.

[alansidman]

It will never hurt to supply a simulated mocked up solution. Personally, I cannot see through to a solution, so I will step aside and hopefully someone will step in.

[GeoffW283]

So, as far as I can see from your data there are 4 groups of 10:
B8:B17, B9:B18, B10:B19, B11:B20.

Shouldn't there be corresponding dates in A8 through A11 ??
If so (and assuming these dates are populated) then the following formula in A6 I think does what you want:

Please Login or Register  to view this content.

Make sure that A6 is formatted as a date.

If the above assumptions are wrong then you need to provide an example with more than just one date to chose from

Hopefully this helps, let us know.

Geoff

[bebo021999]

Attachment 684352
I want to find the date of my max score in a log I am making.
...I'm finding the formula to look for the previous non-blank field to be elusive. Any help is greatly appreciated.

In WS I can see only one date value, is it do you want to populate in A6?
I guess there are more date from row 21.
I yes, try this solution in A6:

Please Login or Register  to view this content.