MODE and Index Match Formula

I'm looking to get the Mode for a column based off of a corresponding column. For example, in column A I have a list of "income ranges" and in column B I have a list of age ranges. I want to say that for each age range, the most frequent (Mode) income range occurred. I've attached a sample of the data.

That works but when you're dealing with a worksheet that has a lot (30,000) rows, then it gets a little messy. Ultimately, I have maybe 10 different age categories in one column and I'm trying to have it look through the "income range" column and pull back whichever income range most frequently corresponds with that particular age range. So out of the 10 age ranges, there's only going to be 10 different income ranges that are matched based off of the frequency by which they've occurred in the rest of the report.

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.

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!!

Sorry, one last issue. This doesn't seem to work for 30,000 rows. I've tested it on up to about 1,000 and that's all that seems to be it's max. Is there anything that I can do to the process that would allow it to work with a much larger data set?