http://s000.tinyupload.com/?file_id=...58182801618578
Sample. Took me a second to scrub the real data out
=IFERROR(INDEX('Work and Formula'!$A$2:$A$1500, MATCH(0,IF(ISBLANK('Work and Formula'!$A$2:$A$1500),1,COUNTIF($A$1:A1, 'Work and Formula'!$A$2:$A$1500)), 0)),"")
Needs to go into column A on "Tier 1" "Tier 2" and "Tier 3" sheets.
The goal is to list all Tier 1 users and pertinent data on Tier 1 workbook, Tier 2 on Tier 2, etc. Criteria for tier is on each Tier worksheet (Cell M4).
Does that make sense? Thanks for the help, guys!
Bookmarks