help with motorsport event results spreadsheet

NoelD

NoelD

New Member
Joined
Apr 16, 2015
Messages
39
Office Version
  1. 2019
Platform
  1. Windows
Hello,

I have a motorsport results spreadsheet and I have two parts to the analysis. Each class gets an FTD [ Fastest Time of Day ] and that winner cannot get the class award. So they are eliminated and the remaining finishers in the class move up a position. I have the formulas working as long as there is a result in the class column cell. if there is no result, I get a value error as per the attached spreadsheet. how can I best achieve what is required and eliminate the error?



AUTOCROSS RESULTS SPREADSHEET =IF(X13=1, "",X13-1)
xyzaaabac ad aeafagahaiajalamanaoapaqarasatauavawax
CLASS 1CLASS 2CLASS 3CLASS 4CLASS 5CLASS 6CLASS 7CLASS 8CLASS 9CLASS 10CLASS 11CLASS 12CLASS 13CLASS 1CLASS 2CLASS 3CLASS 4CLASS 5CLASS 6CLASS 7CLASS 8CLASS 9CLASS 10CLASS 11CLASS 12CLASS 13
CLASS FTDFINISHER POSITIONS
21#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
1#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
32#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
43#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
54#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
1#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
2#VALUE!#VALUE!1#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
3#VALUE!#VALUE!2#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
4#VALUE!#VALUE!3#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
5#VALUE!#VALUE!4#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
6#VALUE!#VALUE!5#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
7#VALUE!#VALUE!6#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Sort by date Sort by votes
Hi NoelD,

Have you try this?
Excel Formula: 
=IFERROR(IF(X13=1, "",X13-1),"")

Hope this helped.
Thanks.
 
Upvote 0
Another option
Excel Formula: 
=IF(or(X13=1,X13=""), "",X13-1)
 
Upvote 0
Glad we could help & thanks for the feedback.
 
Upvote 0
Hello,

I have a further dilemma, in the spreadsheet below. I want to find the Group FTD [ col AB for Class 1 to Class 4 and this has to be repeated over other groups of classes but the overall winner, although first in class, is precluded from winning the class FTD [ Fastest time of Day ] Car 22 finished second in Class 1, so he should get the FTD.....just need a formula for it.

Any help would be fantastic

Noel


1715029076348.png
 
Upvote 0
As this is a significantly different question, it needs a new thread. Thanks
 
Upvote 1
Thank you for the reply. I have posted a new thread now.

Noel
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question Question
Macro to create a new pivot table for each column in a spreadsheet
Replies
0
Views
187
donna_koenig
D
NoelD
  • Question Question
EVENT RESULTS SPREADSHEET HELP
Replies
2
Views
177
Snakehips
Snakehips
WERNER SLABBERT
  • Question Question
Run-time error 70 after code changed
Replies
3
Views
66
RoryA
RoryA
edge37
  • Solved
Replace only cells with zero values with a check mark
Replies
3
Views
47
Fluff
Fluff
A
  • Solved
Could not set the RowSource property. Invalid property value. Error 380
2
Replies
16
Views
208
RoryA
RoryA

Forum statistics

Threads
1,223,888
Messages
6,175,212
Members
452,618
Latest member
Tam84

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top