Hello All,
So i'm inputting statistical information for my fantasy football team to gain an edge on my defensive team since i couldn't snag one of the top defenses. ESPN has great statistical data that I've inputted into a workbook in excel. So now what i'm trying to do is organize the information to be useful.
Goal: =min('Tennessee Titan Defense:Carolina Panthers Defense'!B4) ****PLUS**** I want to pull the team name in a cell next to it or within the same cell to clarify which team has the min
EXAMPLE: Carolina Panthers Defense: 121
It doesn't have to fit specifically the format above but would like to pull the worksheet name in along with the information or else it's useless, I could go through find the min by hand and type it into another workbook.
Let me know if that makes sense and if you have a fix for this!
No rush, this is only due by Thursday as that's when the game is!
