Link to home
Start Free TrialLog in
Avatar of upobDaPlaya
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...
ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of upobDaPlaya
upobDaPlaya

ASKER

Brilliant !  So Simple !