Results from Multiple Tables

[UPSguy]

While working on a project I found that I have too many tables that can be a possible output to a single location. I am looking for a formula to have 1 cell look at all 12 possible cells and decide which is the correct one. Out of the 12 possible cells only one will have information at any given time so there isn't a chance of multiple returns. I have attached a sample sheet that is a copy of my actual worksheet with some notes.

Thank you in advance!

[teylyn]

Hi UPSGuy,

see attached my solution.

I have added a few calculations in a helper column. Please do not delete the gray area with the red numbers. You can hide the column if you want to or make it white text on white background.

The solution basically takes each block of cells and counts all the characters in one block. This is what the numbers in the gray area are.

A combination of MAX() and MATCH() functions then figures out which cell block has the most characters and where it is in the area. This is the cell block you want to duplicate above. The MATCH() output is used by an OFFSET() function to pull the values you want.

Hope it works for you

cheers

[UPSguy]

That will work great!

Thank you!