upobDaPlaya
asked on
Validating Unique Values within a tab and Counting across multiple tabs
I have an Excel spreadsheet with 8 tabs of about 200 records in each tab. I want to
1-For each tab scan the tab and determine if all values are unique for Column A, but ignore evaluating the value called "Filler" in Col A. Note I am only interested if the values are unique within the tab that is in focus, I am not interested in determining if the values are unique across all tabs..
2-Count all cells in Column A across all 8 tabs starting on row 5. This if there 100 cells in each tab then my expected value would be 800. Maybe find last row and do a count function ?
Note I am familiar with a loop and realize I can loop thru each tab to count and find unique values, but I want to find out the most efficient way to do this...
1-For each tab scan the tab and determine if all values are unique for Column A, but ignore evaluating the value called "Filler" in Col A. Note I am only interested if the values are unique within the tab that is in focus, I am not interested in determining if the values are unique across all tabs..
2-Count all cells in Column A across all 8 tabs starting on row 5. This if there 100 cells in each tab then my expected value would be 800. Maybe find last row and do a count function ?
Note I am familiar with a loop and realize I can loop thru each tab to count and find unique values, but I want to find out the most efficient way to do this...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER