Rambo4711,
Attached is an example workbook based on the criteria you described.
Column B has a mix of numbers, text, blanks, and cells with "" in them.
Column D contains the position number you want to return.
Column E gets numbers going from top to bottom with this array formula in cell E3 and copied down:
Column F gets text going from top to bottom with this array formula in cell F3 and copied down:
Column G gets numbers going from bottom to top with this array formula in cell G3 and copied down:
Column H gets text going from bottom to top with this array formula in cell H3 and copied down:
Note that when entering array formulas you have to confirm them with Ctrl+Shift+Enter and not just Enter. That is how the formula becomes surrounded with the curly braces {}. Do not try to add those yourself.
Bookmarks