Various parkrun calculations

ollyhughes1982

Well-known Member
Joined
Nov 27, 2018
Messages
723
Office Version
  1. 365
Platform
  1. MacOS
Hi, I'm having trouble with some worksheets in my parkrun results workbook. Every tab and every cell that are highlighted in yellow are the ones I need to find formulas for. I have manually populated them for now, so you can see what I'm trying to achieve.

I suspect most of them will likely be unique filter type formulas, similar to some I already have in other worksheets. - I have attempted to work these out, but am struggling.

If anyone could help me with any of the formulas for these, it would be greatly appreciated.

parkrun - My parkrun Record - WORKING.xlsx

Thanks in advance!
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
I have now uploaded the individual; cut-down files to Excel Forum. How do I upload a file on here, please?
 
Upvote 0
You can't, but you have already provided a link to your file, so no problems
 
Upvote 0
Thanks. I'm guessing most are of a similar kind solution, but I can't work them out. Thanks again
 
Upvote 0

Forum statistics

Threads
1,217,188
Messages
6,135,101
Members
449,911
Latest member
Omarahmed99

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