This is a sub-function of a NHL bracket I have nearly complete.
I have a list of teams that made the playoffs and their regular season league standing...
1 Vancouver Canucks
2 Washington Capitals
3 Philadelphia Flyers
4 Pittsburgh Penguins
5 San Jose Sharks
6 Detroit Red Wings
(so on so forth, not in the mood to list all 16)
Now, what I want to do with this.... I set up a East and West checkbox system ... so the end user will check if that team is east or west. (and the True, False column will be there, but will be in white print and unviewable to the end-user)
Now here's my snag....
Both West and East .... have teams that rank 1 thru 8 .... I am looking for a way to get Excel (using 2010) to put the teams in the proper category (east or west) and in the proper order for that category. 1 thru 8 within West or 1 thru 8 within East
One last thing, and I think it's a given... this has to be all automated because I want this bracket to be usable regardless of which post-season year it is used.
I hope I was clear in describing this. I know there are brilliant minds on this forum that are more advanced than I am. Hopefully someone knows how to jump this hurdle of mine.
Thank you so much in advance!
Bookmarks