Good Afternoon,
I have 14 different reports that have some similar columns across all reports. I would like to have each column label checked against the whole set of reports headings and return if it is a unique column or if it is not unique and the position where it falls on each report. I'm thinking like a lookup that returns =Column() or maybe a Count in there to see how many times it found in the Array of report headers? Just wondering if anyone has done a similar exercise and has some tips to do it. Thanks for any feedback!
I have 14 different reports that have some similar columns across all reports. I would like to have each column label checked against the whole set of reports headings and return if it is a unique column or if it is not unique and the position where it falls on each report. I'm thinking like a lookup that returns =Column() or maybe a Count in there to see how many times it found in the Array of report headers? Just wondering if anyone has done a similar exercise and has some tips to do it. Thanks for any feedback!