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?
I have a sheet with a year of (365) dates in Row 1 starting in cell B1Under that is a list types of incidents in column AThe 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? Read More