Hey everyone in Column A I have some random numbers and in Column C I have The missing numbers From Column A. Ex:
<tbody>
2
1
3
5
4
7
6
8
9
10
#N/A
1
11
14
12
#N/A
5
13
18
15
</tbody>
Using SMALL(IF(COUNTIF($A$1:$A$130,ROW($1:$130))=0,ROW($1:$130),""),ROW(A1)) IN...