Various parkrun calculations

ollyhughes1982

Well-known Member
Joined
Nov 27, 2018
Messages
718
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

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
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,215,980
Messages
6,128,079
Members
449,418
Latest member
arm56

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