Hello Excelers,
I need one of you to help me out with this one?
Attached is a small example of a larger spreadsheet, I print out for each team their areas, so the print area is from column B to column H. I need a formula in B1 to give me the Team name when I filter the list, for example if I sort by Team C, I want "Team C" to be displayed in B1 or sort by Team D, "Team D" to be displayed. Any ideas?
oldchippy![]()
Bookmarks