How to find the first value upwards in a column.

Hello all,

I am having the following situation.

Column A has different values and some rows are blank.

I want in Column B to check the equivalent cell in column A and work its way upwards until it finds a numerical value, then show that value.

So for example I have this

A
1
blank
blank
2
blank
3
blank
blank
blank
4
5
blank
6

I want in column something like IF(A3="",xxxxx,"") where xxxx is the formula that looks up column A starting from A3 upwards and when it finds the value (i.e in this case "1") to show that value.

I hope I'm making sense.

Regards and thanx for any answers.

K

With Col_A containing various numbers, text, and blanks

This formula returns the last numeric value above a blank cell in Col_A

B1: =IF(A1="",LOOKUP(10^99,$A$1:A1),"")

Example (using your posted data):

Please Login or Register  to view this content.

Does that help?