Re: Sorting Motorsports Statistics

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


To: Davesexcel,

Thanks for your reply. To anser the first part of your question, is
yes the numbers stay in one spot, let's say either Total Points or
Winnings, but the drivers names do not change or rotate along with the
sort. The cells are relative value.

The second part of your question would be yes. I would like to sort by
each individual category one at a time. In tracking real-life stats, at
then end of race 10 let's say, I want to know what driver in leading in
points, Greg Biffle, Jeff Gordon, etc. Then I may want to sort by
prize money or top 5's.

davesexcel Wrote:
Your first issue sounds like an absolute problem, when you sort the
numbers stay in one spot is that right? do you have the cells as a
relative or absolute value from the data sheet??

So you are sorting each individual catagory one at a time, and then at
the far right total up the rankings to get the total placements of
your
league.

I remember having this type of problem in a hocky fantasy draft
many,many years ago, I am sure it has to do with relative or absolute
values, if it is an absolute problem, you need the $A$ signs, goto
edit
(say the refernce row is A)
find A
replace with $A$
do this in the sheet that you are doing your sorting do a test run
first to make sure that is the problem:mad:


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=31708
View this thread:
http://www.excelforum.com/showthread.php?threadid=517432


--
fetzer
.

Relevant Pages

  • Re: Interesting story
    ... What sort of boats does your group have, ... The good thing about your spot is that while it's freezing water now, ... kayaks disappear at any distance farther than 1000 meters. ...
    (rec.sport.rowing)
  • Re: Interesting story
    ... What sort of boats does your group have, ... I thought the Spot and EPIRB were two different technologies, ... If I had a signal on those two I'd monitor it like a crazy man. ...
    (rec.sport.rowing)
  • RESULTS - for the curious
    ... fold & get my remaining 700 in at a better spot. ... >> absolute horrid run of cards. ... >> folds back around to me. ... >> sub question - if it's worth pushing, ...
    (rec.gambling.poker)
  • Re: Caution Concerning the New Day Dawning
    ... device, like a long distance taser, the only thing cops have is a gun. ... in a vital spot, ... Maybe some sort of manslaughter or unintentional thing?.... ... Let's not forget that fleeing suspects who disregard police warnings to stop ...
    (soc.retirement)
  • Re: How do i...
    ... That said, *if* you feel the user needs to see some underlying unique, ... The Absolute ... changed the sort order or filtering. ...
    (microsoft.public.access.formscoding)