HI all,

I have a formula that calculates the most commonly occuring string value in a long column:

=INDEX('The List'!C$2:C$4999,MATCH(LARGE(COUNTIF('The List'!C$2:C$4999,'The List'!C$2:C$4999),1),COUNTIF('The List'!C$2:C$4999,'The List'!C$2:C$4999),0))

But when I try to use a similar formula to look up the next column, it returns a '#N/A' value.

=INDEX('The List'!D$2:D$4999,MATCH(LARGE(COUNTIF('The List'!D$2:D$4999,'The List'!D$2:D$4999),1),COUNTIF('The List'!D$2:D$4999,'The List'!D$2:D$4999),0))

I can't understand why it works with one column and not another. The data is all string in both, and the cells are formatted as 'TEXT'.

Thanks