Excel Help
Hi guys!
I have a problem with Excel and wonder if any of you guys could help me.
THE PROBLEM:
I am creating a Fantasy Football game and have a problem with my worksheet. I instructed Excel to copy a players info but when I sort the table with all players in then the formula gets mixed up and looks at a wrong player. I know that the dollar sign can fix this but I am unsure of where to put it. The formula is then replicated across a few cells and if this problem could be fixed then the game would work fine.
My formula is:
=Goalkeepers!Cell_Number
=Defenders!Cell_Number
=Midfielders!Cell_Number
=Strikers!Cell_Number
Abhishek Reddy posted this at 14:11 — 5th October 2002.
He has: 3,348 posts
Joined: Jul 2001
It might just be me, but I may be able to help further if I could possibly see the book itself...
Or maybe a little more info, like what data you're fetching etc.
Timewell posted this at 15:30 — 5th October 2002.
They have: 344 posts
Joined: Jun 2002
Yeah if you want to see it then I will send it to your e-mail...
Timewell posted this at 15:31 — 5th October 2002.
They have: 344 posts
Joined: Jun 2002
oh...I can't
Timewell posted this at 22:34 — 5th October 2002.
They have: 344 posts
Joined: Jun 2002
I will send it to you if you PM me your e-mail!
Timewell posted this at 15:28 — 8th October 2002.
They have: 344 posts
Joined: Jun 2002
Any ideas on what the problem is yet guys????
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.