Hey everyone in Column A I have some random numbers and in Column C I have The missing numbers From Column A. Ex:
<tbody>
</tbody>
Using SMALL(IF(COUNTIF($A$1:$A$130,ROW($1:$130))=0,ROW($1:$130),""),ROW(A1)) IN COLUMN C1 and dragdown
What I need done in Column B is if anywhere column A=ISNA than B to pull the value in C using the above ex. B6=1 and B8=5. Also if the value of A3 goes from 4 to #N/A than column C does give me 1,4,57,8 etc using the formula above so therefore the value of B3=1, B6=4, and B8=5
I think this needs an if with index formula or vlookup but I don't know how to put it together. any help and/or ideas would be greatly appreciated
2 | 1 | |
3 | 5 | |
4 | 7 | |
6 | 8 | |
9 | 10 | |
#N/A | 1 | 11 |
14 | 12 | |
#N/A | 5 | 13 |
18 | 15 |
<tbody>
</tbody>
Using SMALL(IF(COUNTIF($A$1:$A$130,ROW($1:$130))=0,ROW($1:$130),""),ROW(A1)) IN COLUMN C1 and dragdown
What I need done in Column B is if anywhere column A=ISNA than B to pull the value in C using the above ex. B6=1 and B8=5. Also if the value of A3 goes from 4 to #N/A than column C does give me 1,4,57,8 etc using the formula above so therefore the value of B3=1, B6=4, and B8=5
I think this needs an if with index formula or vlookup but I don't know how to put it together. any help and/or ideas would be greatly appreciated