Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Find numbers lower / further than the previous (Track & Field)

I'm new to Office 2007, so am a little vaig on what to do. I'm trying to
automate a Recod of Events (Times/ Distances) in Ecxell but can not get it to
do what I want. Each time a Persanal Best is attained, all the functions I've
tried would only tell me it was faster/further than the first time/distance,
not the previous best.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 53
Default Find numbers lower / further than the previous (Track & Field)

Try using the

"rank" function.....it will give you the rank of all the timings.. Also, if
you can post some temp data I can make the proper formula for you.

--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India


"Mal/Betty" wrote:

I'm new to Office 2007, so am a little vaig on what to do. I'm trying to
automate a Recod of Events (Times/ Distances) in Ecxell but can not get it to
do what I want. Each time a Persanal Best is attained, all the functions I've
tried would only tell me it was faster/further than the first time/distance,
not the previous best.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,346
Default Find numbers lower / further than the previous (Track & Field)

Hi,

A little vague on the data layout.

Suppose you run (ha!) one set of data for an event across a row with the
better results to the right. Suppose your data for an event starts in D2 and
you want the improvement to show in B2. Later performances going to the
right of D2.

Suppose the event you are tracking is javelin distances then your formula
would be
=LARGE(D2:N2,1)-LARGE(D2:N2,2)
Where you can increase N2 as much as you like.
If you were tracking something like time to swim a mile you could use
=SMALL(D2:N2,1)-SMALL(D2:N2,2)
You can handle both with one much more complex formula:
=ABS(LOOKUP(10^10,D3:N3)-INDEX(D3:N3,1,MATCH(MAX(COLUMN(D3:N3)*(D3:N3<"")) ,COLUMN(D3:N3)*(D3:N3<""),0)-1))

This last formula is an array which means to enter it you press
Shift+Ctrl+Enter

If these help, please click the Yes button.

Cheers,
Shane Devenshire

"Mal/Betty" wrote:

I'm new to Office 2007, so am a little vaig on what to do. I'm trying to
automate a Recod of Events (Times/ Distances) in Ecxell but can not get it to
do what I want. Each time a Persanal Best is attained, all the functions I've
tried would only tell me it was faster/further than the first time/distance,
not the previous best.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find Text (Lower or Upper Case) [email protected] Excel Discussion (Misc queries) 4 August 11th 08 11:42 AM
Get lower half of a column of numbers EllenM Excel Worksheet Functions 2 June 7th 08 03:47 PM
Using "track changes" to revert to a previous save Sean Carter Excel Discussion (Misc queries) 3 May 23rd 05 04:54 AM
How can I find the row nr of the first number lower/ higher then a vmv Excel Discussion (Misc queries) 3 February 9th 05 03:03 AM
Pivot table help:calculated field based on previous consecutive va martin Excel Discussion (Misc queries) 0 December 9th 04 09:33 PM


All times are GMT +1. The time now is 06:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"