I have a list of values in Excel, separated by arbitrary spaces/text. I'm trying to find a function that gets the last numeric entry in the column above the row location I'm currently at, and autofill the cell I'm at with it (or let me perform operations on it). Is this possible?
| Column A |
|---|
| 95000 |
| 46000 |
| NA/BLANK |
| NA/BLANK |
| 52423 |
| NA/BLANK |
| < Fill 52423 here > |
I've tried LOOKUP but couldn't get it to work. Thoughts?
CodePudding user response：
I'm assuming when you say, the row location I'm currently at you essentially want an 
CodePudding user response：
Try INDEX/MATCH like-
=INDEX(A1:A6,MATCH(99^9,A1:A6))
