Excel Help

They have: 344 posts

Joined: Jun 2002

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's picture

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... Wink

Or maybe a little more info, like what data you're fetching etc. Smiling

They have: 344 posts

Joined: Jun 2002

Yeah if you want to see it then I will send it to your e-mail...

They have: 344 posts

Joined: Jun 2002

oh...I can't

They have: 344 posts

Joined: Jun 2002

I will send it to you if you PM me your e-mail!

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.