Hello all,
I have a excel file with 4 columns which are a result of vlookups. Below you can find some data which I am seperating with a semi-column.
Abc;finance;highstreet;#N/A
Der;N/A;highway;3000$
Poz;r&d;parklane;4000€
As you can see, the first two lines contain a cell which is ‘#N/A’. I would like to automate that all rows with an N/A record are listed in a seperate ‘issue file’ which can track data quality.
How should I approach this?
Thanks in advance!