Hi, I have a consolidated dummy data set of multiple excel files-In actuality around 700 excels consolidated in the real data. I have a column called filename which varies for each excel. I used a batch macro to consolidate all this data-so all the column headers have come in this dataset. Not all column headers are applicable for all files-I'm looking to find out which excels-aka filesnames are same in terms of column headers i.e. data in those columns isnt null and which are different i.e. the column info is null in them vs other excels (filenames) without null column names for the same column header. I tried filtering on filenames(which obviously won't work considering 700 excels)-multi-join also isnt working considering I want to know which filenames don't match on the column headers-A macro solution is what would be required here. Nevertheless, i'm attaching the dummy data as a starting point here. Ultimately I want a summary list of how many filenames have columns matching/how many are different.
