Search results

You are awesome!!!!! Thank you sooo much!!! Works Perfectly! Just had to change =OFFSET('2010'!$A$2,MATCH('Top Performers'!$A19,'2010'!$AM$3:$AM$36,0),COLUMN()-1) to =OFFSET('2010'!$A$2,MATCH('Top Performers'!$A19,'2010'!$AM$3:$AM$36,0),COLUMN()-2) to get the players names in and move...

I went back through multiple times from scratch and now I just keep ending up with #DIV/0! error in the 2010!D3 row with the blank cells and the AM column as well, with #N/A Here's what I have maybe I did something wrong...

plus that put #### in the 2010! AM column as well

No that didn't help, plus I have the #DIV/0! error in the 2010!D3 row with the blank cells

I tried those and I get #N/A accross the whole Top Performers table AM3-AM36 cells show "2" in all of them. Rory

Also since your going to take a look at it my next question would be, how could I get the "Player", "Pos" and "Team" to follow in the same row? Thanks a Ton! Rory

I just stuck it on my website for easy access www.ilovebodyjewelry.com/prodimages/FantasyFootball-2010.xls The "Top Performers-Test" page is where I have the formula. Rory

I tried that and I get a #N/A and "A value is not available to the formula or function" All cells in the formula have values in them??? I tried these and all the same: =LARGE(ROUNDDOWN('2010'!$D$3:$D$5+'2010'!$D$8:$D$13,0),ROW(A1))...

Well I needed a formula for the table I want to use on the "Top Performers" worksheet. I have got this to work =LARGE(ROUNDDOWN('2010'!$D$3:$D$5,0),$A14:$A37) "2010" is the sheet I'm pulling from $D$3:$D$5 is the 1st group/array $A14:$A37 is the list from #1-24 My problem is I can't get...

Hello, I'm pretty much a rookie at excel but learn quickly. To be completely forward I am making excel spreadsheets for my fantasy football league and we want something we can track, organize and have readily available for viewing each week. Plus to be able to have all those stats going...