I've been comparing between two CSV files and managed to do it using the following formula:
=VLOOKUP(A2;'file.csv'!$A$2:$AD$9890;1;FALSE)
I am comparing only the first column in each worksheet, so I get a resulting column that tells me which values are new (the difference between the two sheets). The column has some #N/A values. Now, is there a way to bring these #N/A values to the top?
Example:
N/A
N/A
N/A
N/A
77851
7452
6524
10522
4522
One approach is to use autofilter to achieve that.
Assume I have the following data, where I have the lookup value =VLOOKUP(B2;$H$3:$I$6;2;0) in cell E2
I would put a filter on my headers (row 1) and create dummy column (Column A) with values 1 and upward.
When you filter the lookup column "Sort Largest to Smallest" the #N/A values will be all on the top.
The dummy row is only to "restore" your data as it was from the beginning. Not necessary for the filter, but could be nice to have.
