PDA

View Full Version : Misc anyone here good with excel or OOC?


healthpellets
04-29-2009, 08:54 PM
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

Lumpy
04-29-2009, 08:58 PM
Excel has a sort function under the 'data' tab. Did u try that yet?

healthpellets
04-29-2009, 09:01 PM
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.

Lumpy
04-29-2009, 09:05 PM
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).

healthpellets
04-29-2009, 09:09 PM
effing brilliant. thanks for the help.

healthpellets
04-29-2009, 09:10 PM
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?

Lumpy
04-29-2009, 09:11 PM
No problem. Glad I could help. :D

Lumpy
04-29-2009, 09:15 PM
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.

Lumpy
04-29-2009, 09:26 PM
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.

healthpellets
04-29-2009, 09:33 PM
thanks much. enjoy your evening.

Buehler445
04-29-2009, 09:45 PM
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.

RJ
04-29-2009, 09:57 PM
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.

Sandyskc
04-29-2009, 10:02 PM
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.

prhom
04-29-2009, 10:07 PM
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.

healthpellets
04-29-2009, 10:29 PM
brilliant! you're all brilliant! problem solved. much love.