Hi, I'm looking for some help with an OFFSET / COUNT formula (this may not be the correct choice for what I am trying to do).
I have 2 sheets.
Sheet 1 - List of Athletes, with 4 columns.
Athlete No - Name - Club - Age
Sheet 2 - Result Sheet based on Age, with a number of columns, the first 3 being.
Athlete No - Name - Club
I intend to populate Sheet1 first, I would like Sheet2 to auto-populate with the details of the Athletes listed on Sheet1 of a particular age. e.g. If the Result Sheet is for Senior Women then all athletes listed as 'Senior Women' will appear automatically.
I have included an example SS, and I have placed the formula that I have been playing with in the cells Athlete No - Name - Club on Sheet2. My formula is finding the first correctly aged athlete, but then inserting all subsequent athletes regardless of age. I dont think I'm far away....
Any help would be greatly appreciated.
BB
Bookmarks