CODEWITHSUNDEEP
google-sheetsmaxifs
c492681
c492681

Reputation: 1

Google Sheets - get date of max value

I would like to populate a cell which gives me the date where sales was the highest for that period. eg. if I have 2 months, I would like to have a cell saying 14/01/2023 if that was the day with the highest sales. Q - sales values R - Year I can get the highest sales value for the year:

=MAXIFS(Pivot!Q2:Q1000, Pivot!R2:R1000, "2023")

but struggle to get the highest date using similar as it just brings back the max date.

I have another column P which is the date. Anyone have any thoughts as to how to do this? To recap I want the date of the most sales - this year.

Thanks

Upvotes: 0

Views: 308

Answers (1)

rockinfreakshow
rockinfreakshow

Reputation: 30289

Can you try:

=filter(Pivot!P2:P,Pivot!R2:R=2023,Pivot!Q2:Q=max(Pivot!Q2:Q))

Upvotes: 0

Related Questions