I'm writing a formula to look through a table of data and find the email address that has the max count according to data entered into the formula. I have it written out and working, but after the first answer it keeps returning the same wrong answer even with blank cells, which is making think it is an error. I have used ctrl+shift+enter to get it to run as an array.
I've looked through the code when I drag it down to rows below and I have verified that it is looking for the correct input cells in the formula. Some of the emails may have two or more that are max with the max being or 3. I'll cross that bridge later, but for now the inputs that I know have a definitive max are not outputting correctly either.
=INDEX('[Load List Reference.xlsx]Sheet1'!$D$1:$D$7454,MATCH(MAX(COUNTIFS('[Load List Reference.xlsx]Sheet1'!$D$1:$D$7454,'[Load List Reference.xlsx]Sheet1'!$D$1:$D$7454,'[Load List Reference.xlsx]Sheet1'!$G$1:$G$7454,E3,'[Load List Reference.xlsx]Sheet1'!$I$1:$I$7454,G3)),COUNTIFS('[Load List Reference.xlsx]Sheet1'!$D$1:$D$7454,'[Load List Reference.xlsx]Sheet1'!$D$1:$D$7454,'[Load List Reference.xlsx]Sheet1'!$G$1:$G$7454,E3,'[Load List Reference.xlsx]Sheet1'!$I$1:$I$7454,G3)))
I need it to return the correct email address associated with the max number of times it appears in the data. It is showing correctly for the first row, but after that it is outputting the last email address from the list. When there isn't even any data in the search columns it is still outputting that email address.
