Lookup values against number of times occurring

Status
Not open for further replies.

ollyhughes1982

Well-known Member
Joined
Nov 27, 2018
Messages
793
Office Version
  1. 365
Platform
  1. MacOS
Hi,

This is a further request re my recent post, solved by RobP. I think the second part of it is significant enough to warrant a separate post, as RobP solved the initial request. You can see the earlier thread at the link below:

Run at parkrun events different numbers of consecutive times

Re the below two images, I am trying to come up with a formula in column B4:B2003 of the ‘All Completed Runs - Rutter T’ worksheet, to find when an event (venue) has been completed the number of times stated in column A4:A2003. In the images (and linked file), I have populated these manually (in yellow), to illustrate what I am trying to achieve.

Part 1.jpg
Part 2.jpg


If multiple events have been completed the same number of times I would like to show the event name and date completed of the most recent one completed that number of times.

The ‘All Completed Runs’ worksheet is the original source data.

Link to file (small file and will open quickly) is here: Rutter Triangle.xlsx

Thanks in advance!

Olly.
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread.
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,223,908
Messages
6,175,307
Members
452,633
Latest member
DougMo

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