sobrien1234
Board Regular
- Joined
- May 10, 2016
- Messages
- 175
- Office Version
- 365
- Platform
- Windows
I have the following:
Column EN - set of codes which represent dates and race numbers (i.e. the formula in EN is =concatenate (date,race number) so it provides a unique code for each race
Column BJ - list of numbers which represent the horses best rating and is different for cell
I want a formula for column EO that finds the largest rating each race in EN. The answer should be the same number for every horse running in that same race - i.e the unique date/race in EN. I have 50,000 rows of data so need to be able to copy the formula down the list.
Hope that makes sense?
Seamus
Column EN - set of codes which represent dates and race numbers (i.e. the formula in EN is =concatenate (date,race number) so it provides a unique code for each race
Column BJ - list of numbers which represent the horses best rating and is different for cell
I want a formula for column EO that finds the largest rating each race in EN. The answer should be the same number for every horse running in that same race - i.e the unique date/race in EN. I have 50,000 rows of data so need to be able to copy the formula down the list.
Hope that makes sense?
Seamus
