Forum Discussion
Solved
Formula help please
I have a sheet with a year of (365) dates in Row 1 starting in cell B1
Under that is a list types of incidents in column A
The requirement is to look through each day per incident type to find the Max number of incidents and the date of that 'peak'. I can find the maximum number in the row with a formula. But what do I need to add to give me the (Vector?) of the corresponding date that will be above in Row 1?
=TAKE(FILTER($B$1:$NC$1,B2:NC2<>""),,1) =TAKE(FILTER($B$1:$NC$1,B2:NC2<>""),,-1) =INDEX($B$1:$NC$1,AGGREGATE(15,6,COLUMN($B$1:$NC$1)/(B2:NC2<>""),1)-1) =INDEX($B$1:$NC$1,AGGREGATE(14,6,COLUMN($B$1:$NC$1)/(B2:NC2<>""),1)-1)
15 Replies
- Detlef Thank you.
But that does not work for me. Could it be because I am using Excel Mac 16.78 on Mac OS Monterey 12.7.4?
Using your suggestion I get: #name?You should update. The latest version is 16.84 from April 2024.
https://learn.microsoft.com/en-us/officeupdates/update-history-office-for-mac
