ac-n-mike said:
Yea, the betters took a beating this week.
However, I did go 10-4.....boooyah!
Football Pick ' em Week 4
- Thread starter bhelser
- Start date
Yea, the betters took a beating this week.
However, I did go 10-4.....boooyah!
bhelser said:
Woooo Hoooo
Seahawkz37
Bench Warmer
Congrats 0264! #11 isn't bad I guess. I like the spreadsheet you have it set as.
bhelser said:
I am going to take a look at it and see if I can't work the totals formula. So it automatically calculates everything but the two lowest totals. I think it can be done, but pretty busy at work. Except for now of course while I each my lunch....
anferneepenny
I'm Bored
Hey I hate to be a pain but can somebody tell me what place I'm in I cant open the file.THANKS I know I stunk it up
Hugo
Bench Warmer
i can't get it to open can someone post the list!
Seahawkz37
Bench Warmer
There's the first 25 or so up there (Hugo - #45)
anferneepenny
I'm Bored
Thanks 17th not to bad
Hugo
Bench Warmer
Seahawkz37 thanks for the list
PKHale007
Bench Warmer
Hey I moved from 51 to 40............maybe next week I can crack the top 30....
coltstopps
Bench Warmer
bhelser said:yeah I don't know a formula to calculate arow of data (minus the lowest two) so I just enter everyone lowest 2 scores.....If you can all the more power to you!!! and maybe I will send a little something extra to you with your prize
Try this ...
Code:
=SUM(D3:T3)-(SMALL(D3:T3,2)+SMALL(D3:T3,1))put it in the cell U3 then copy it down ....
balance13
Bench Warmer
CAn someody lmk my postion.
Thanks,.
Steven
Thanks,.
Steven
