CODEWITHSUNDEEP
google-sheetsmaxmatchgoogle-sheets-formula
h.and.h
h.and.h

Reputation: 776

What formula can I use to get a cell associated with the result of MAX() in Google Sheets?

enter image description here

BEST MAX is MAX(B7:X7)

What formula can I use to get the associated date with the BEST MAX?

The pink box should read "7/13", located at G1, and if the next week were the new BEST MAX, then the total would need to read "7/20", located at H1.

Thanks!

Upvotes: 1

Views: 42

Answers (1)

player0
player0

Reputation: 1

try:

=INDIRECT(ADDRESS(1, 1+MATCH(B11, B7:X7, 0)))

or shorter:

=INDIRECT(ADDRESS(1, MATCH(B11, 7:7, 0)))

Upvotes: 2

Related Questions