I need the wisdom of the Gurus, please help! I run a very large report every 2 weeks for my department. This is a report that I have taken on and I'm hoping to add some efficiencies to help with user review of the data. All iterations of the report are contained in one workbook with each new/updated report being added as a table in a new tab. Each tab is titled with the date date of the data pull. Each data table contains the same column headers i.e., "Client" will always be column A, "Facility" will be column B, and "Unique" will always be column C. Below is an image of the first few columns of the report.
The column I would like to focus on is the "Unique" column. What I'm wondering if there is a formula or array formula I can enter into a new column added next to Unique column, for now I'm calling this column "Report Steak", that would report the number of times the unique value is constantly found in the immediate previous tabs or data pulls. For example, if the unique values is found in the immediate last 2 tabs (data pull dates), the Report Streak Column would show 2. If the unique is found in the last 5 tabs, the Streak column would report 5. If the value is not found the column would report some form of Null, I don't care if this is #N/A or "0". Please see the image for an example of I"m picturing. I believe it would be some form of "sumproduct" and "frequency" but I'm not sure because I am not very familiar with those functions.
Please let me know if you have any questions and thanks for the help!
Isaac
Please let me know if you have any questions and thanks for the help!
Isaac
