MODE and Index Match Formula

Originally Posted by dash11

That shouldn't occurr since I have over 30,000 rows of data, but if by chance it did, I would want it to take the first once since I can sort the results from highest to lowest.

I found only one category range that could even yield a mode.....70-80 year olds mode range $60k-$75k. (Yields {"";"";"";60;"";20;"";"";60;"";"";"";"";"";"";"";"";"";"";"";"";"";"";""} for the lower limits.) The rest all have unique numbers.

I pulled the lower limits out of the ranges and made a lookup table.

File attached.

Your magic worked perfectly! Thank you kindly!

I think the issue has something to do with the data set being so large (31,000 Rows), which is why it isn't working correctly. I've attached the complete worksheet to see if you might be able to help me troubleshoot the issue. I greatly appreciate your help with this one!!