Home Mail MemberMap Chat (0) Wallpapers
Go Back   ChiefsPlanet > The Lounge

Reply
 
Thread Tools Display Modes
Old 04-29-2009, 08:54 PM  
healthpellets healthpellets is offline
Long Live John Galt
 
healthpellets's Avatar
 
Join Date: Nov 2008
Location: On the edge of reason
Casino cash: $5000
anyone here good with excel or OOC?

i'm trying to make a functional spreadsheet to use for fantasy rankings / projections. i need to have some cells performing functions, but i want to be able to move rows around without having to reformat the functions. know what i mean? i can do the basics, but don't know enough to accomplish what i want.

if you have something like this and would be willing to share, attach it to your reply or pm me for my email. thanks.

-hp
Posts: 1,869
healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.
  Reply With Quote
Old 04-29-2009, 08:58 PM   #2
Lumpy Lumpy is offline
MVP
 
Lumpy's Avatar
 

Join Date: Sep 2007
Casino cash: $5000
Excel has a sort function under the 'data' tab. Did u try that yet?
__________________


Quote:
Originally Posted by Lumpy View Post
I had a dream about Peyton Manning and pig fishing last night. I don't know what it means, but I blame you assholes!
Posts: 8,809
Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.
  Reply With Quote
Old 04-29-2009, 09:01 PM   #3
healthpellets healthpellets is offline
Long Live John Galt
 
healthpellets's Avatar
 

Join Date: Nov 2008
Location: On the edge of reason
Casino cash: $5000
if i highlight the column and sort, it reorders that column, which is fine, but doesn't reorder the remaining sheet based on the results of that sort. which is what i want.
Posts: 1,869
healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.
  Reply With Quote
Old 04-29-2009, 09:05 PM   #4
Lumpy Lumpy is offline
MVP
 
Lumpy's Avatar
 

Join Date: Sep 2007
Casino cash: $5000
Try highlighting all the columns, then perform a sort. Be sure to select 'Header Row' if u have a header, (i.e. a title for each column).
__________________


Quote:
Originally Posted by Lumpy View Post
I had a dream about Peyton Manning and pig fishing last night. I don't know what it means, but I blame you assholes!
Posts: 8,809
Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.
  Reply With Quote
Old 04-29-2009, 09:09 PM   #5
healthpellets healthpellets is offline
Long Live John Galt
 
healthpellets's Avatar
 

Join Date: Nov 2008
Location: On the edge of reason
Casino cash: $5000
effing brilliant. thanks for the help.
Posts: 1,869
healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.
  Reply With Quote
Old 04-29-2009, 09:10 PM   #6
healthpellets healthpellets is offline
Long Live John Galt
 
healthpellets's Avatar
 

Join Date: Nov 2008
Location: On the edge of reason
Casino cash: $5000
is there a way to apply a function that i've written to every cell in a column without having to paste in it each cell and change the numbers based on the row?
Posts: 1,869
healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.
  Reply With Quote
Old 04-29-2009, 09:11 PM   #7
Lumpy Lumpy is offline
MVP
 
Lumpy's Avatar
 

Join Date: Sep 2007
Casino cash: $5000
No problem. Glad I could help.
__________________


Quote:
Originally Posted by Lumpy View Post
I had a dream about Peyton Manning and pig fishing last night. I don't know what it means, but I blame you assholes!
Posts: 8,809
Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.
  Reply With Quote
Old 04-29-2009, 09:15 PM   #8
Lumpy Lumpy is offline
MVP
 
Lumpy's Avatar
 

Join Date: Sep 2007
Casino cash: $5000
Quote:
Originally Posted by healthpellets View Post
is there a way to apply a function that i've written to every cell in a column without having to paste in it each cell and change the numbers based on the row?
Um, I think u might be hosed. Stand by.
__________________


Quote:
Originally Posted by Lumpy View Post
I had a dream about Peyton Manning and pig fishing last night. I don't know what it means, but I blame you assholes!
Posts: 8,809
Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.
  Reply With Quote
Old 04-29-2009, 09:26 PM   #9
Lumpy Lumpy is offline
MVP
 
Lumpy's Avatar
 

Join Date: Sep 2007
Casino cash: $5000
I would say that if the copy/paste method isn't too tedious for u, I would stick w/ that if ur in a hurry to get it done. Otherwise, when u have more time, do a search in the help library.
__________________


Quote:
Originally Posted by Lumpy View Post
I had a dream about Peyton Manning and pig fishing last night. I don't know what it means, but I blame you assholes!
Posts: 8,809
Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.Lumpy is a favorite in the douche of the year contest.
  Reply With Quote
Old 04-29-2009, 09:33 PM   #10
healthpellets healthpellets is offline
Long Live John Galt
 
healthpellets's Avatar
 

Join Date: Nov 2008
Location: On the edge of reason
Casino cash: $5000
thanks much. enjoy your evening.
Posts: 1,869
healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.
  Reply With Quote
Old 04-29-2009, 09:45 PM   #11
Buehler445 Buehler445 is offline
Supporter
 
Buehler445's Avatar
 

Join Date: Apr 2007
Location: Scott City KS
Casino cash: $17067
Quote:
Originally Posted by healthpellets View Post
is there a way to apply a function that i've written to every cell in a column without having to paste in it each cell and change the numbers based on the row?
If it references the column, you should be able to copy/paste or drag it down.
Posts: 22,791
Buehler445 is obviously part of the inner Circle.Buehler445 is obviously part of the inner Circle.Buehler445 is obviously part of the inner Circle.Buehler445 is obviously part of the inner Circle.Buehler445 is obviously part of the inner Circle.Buehler445 is obviously part of the inner Circle.Buehler445 is obviously part of the inner Circle.Buehler445 is obviously part of the inner Circle.Buehler445 is obviously part of the inner Circle.Buehler445 is obviously part of the inner Circle.Buehler445 is obviously part of the inner Circle.
  Reply With Quote
Old 04-29-2009, 09:57 PM   #12
RJ RJ is offline
Bon vivant....occasionally.
 
RJ's Avatar
 

Join Date: Oct 2000
Location: In a shotgun shack
Casino cash: $5047
If you're willing to invest a few $.


http://www.rotolab.com/football-draftlab.htm


I've not tried the football version but the baseball version is great, I've been using it for 5 years.
Posts: 14,767
RJ 's adopt a chief was Sabby PiscitelliRJ 's adopt a chief was Sabby PiscitelliRJ 's adopt a chief was Sabby PiscitelliRJ 's adopt a chief was Sabby PiscitelliRJ 's adopt a chief was Sabby PiscitelliRJ 's adopt a chief was Sabby PiscitelliRJ 's adopt a chief was Sabby PiscitelliRJ 's adopt a chief was Sabby PiscitelliRJ 's adopt a chief was Sabby PiscitelliRJ 's adopt a chief was Sabby PiscitelliRJ 's adopt a chief was Sabby Piscitelli
  Reply With Quote
Old 04-29-2009, 10:02 PM   #13
Sandyskc Sandyskc is offline
Starter
 

Join Date: Sep 2003
Location: Lee's Summit
Casino cash: $5231
There is a function in Excel called auto complete. When you click on a cell, there is a small black square in the lower right corner. Put your cursor on that square and drag it down the column. It should copy the formula for you and adjust the cell references for that row.
Posts: 202
Sandyskc is the dumbass Milkman is always talking aboutSandyskc is the dumbass Milkman is always talking aboutSandyskc is the dumbass Milkman is always talking aboutSandyskc is the dumbass Milkman is always talking aboutSandyskc is the dumbass Milkman is always talking aboutSandyskc is the dumbass Milkman is always talking aboutSandyskc is the dumbass Milkman is always talking aboutSandyskc is the dumbass Milkman is always talking aboutSandyskc is the dumbass Milkman is always talking aboutSandyskc is the dumbass Milkman is always talking about
  Reply With Quote
Old 04-29-2009, 10:07 PM   #14
prhom prhom is offline
Veteran
 

Join Date: Nov 2007
Location: Denver
Casino cash: $5367
Quote:
Originally Posted by healthpellets View Post
is there a way to apply a function that i've written to every cell in a column without having to paste in it each cell and change the numbers based on the row?
You have three options; double-click the lower right-hand corner of the cell, click and drag the lower right-hand corner down as far as you want the formula to go, or copy the cell with the formula then highlight the range of cells you want that formula to be copied in and select paste (CTRL+V). Let us know if that doesn't work.
Posts: 1,319
prhom must have mowed badgirl's lawn.prhom must have mowed badgirl's lawn.prhom must have mowed badgirl's lawn.prhom must have mowed badgirl's lawn.prhom must have mowed badgirl's lawn.prhom must have mowed badgirl's lawn.prhom must have mowed badgirl's lawn.prhom must have mowed badgirl's lawn.prhom must have mowed badgirl's lawn.prhom must have mowed badgirl's lawn.prhom must have mowed badgirl's lawn.
  Reply With Quote
Old 04-29-2009, 10:29 PM   #15
healthpellets healthpellets is offline
Long Live John Galt
 
healthpellets's Avatar
 

Join Date: Nov 2008
Location: On the edge of reason
Casino cash: $5000
brilliant! you're all brilliant! problem solved. much love.
Posts: 1,869
healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.healthpellets must have mowed badgirl's lawn.
  Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump




All times are GMT -6. The time now is 03:15 AM.


This is a test for a client's site.
A new website that shows member-created construction site listings that need fill or have excess fill. Dirt Monkey @ https://DirtMonkey.net
Powered by vBulletin® Version 3.8.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.