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.
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!