Hello, I have been kindly given the following code to work out the most frequently occurring entry is in a list:

=LOOKUP(REPT("Z",255),CHOOSE({1,2},"",INDEX('All Incidents'!$D$1:$D$1085,MODE(IF(('All Incidents'!$D$1:$D$1085<>"")*ISNA(MATCH('All Incidents'!$D$1:$D$1085,$E$10:$E10,0)),MATCH('All Incidents'!$D$1:$D$1085,'All Incidents'!$D$1:$D$1085,0))))))

Committed with CTRL + SHIFT + ENTER
What I would like to do is adapt it so it shows the most popular entry for a Month

I have a collumn in the spreadsheet with the numeric month value 1 being January through to 12 being December

These numeric month values are in collumn "O"

I have a COUNTIF and SUMPRODUCT statement but I didn't get anywhere.

Can anyone help?