Forum Discussion
Examine multiple columns to find missing data
I'd do that with Power Query not to import each time csv files and generate reporting tables from scratch. All could done one time, after only place updated csv into the folder and press Refresh.
To show missed items - depends on which Excel version / platform you are and how you'd like to show. For example that could be =IFERROR( FILTER( full list, COUNTIF(target list, full list) = 0 ), "nothing is missed" )
I'd do that with Power Query not to import each time csv files and generate reporting tables from scratch. All could done one time, after only place updated csv into the folder and press Refresh.
To show missed items - depends on which Excel version / platform you are and how you'd like to show. For example that could be =IFERROR( FILTER( full list, COUNTIF(target list, full list) = 0 ), "nothing is missed" )
