Formula to find largest number in a list

[sobrien1234]

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

 

[etaf]

a pivot table may do what you want

EN = date & Race Number
BJ = Horse Rating
?? = Horse itself
?? = Date
?? = Race


Where is the largest Rating , is this BJ you want to find the largest rating for each race and date
Not sure what you mean by

The answer should be the same number for every horse running in that same race - i.e the unique date/race in EN.

so if you have two horses

Horse AAA
Horse BBB
and they both run
on the same race same day Race number 123
then EN will be
03/03/2018-123

If horse AAA has a rating of 67
and horse BBB has a rating of 88

Not sure what the output is
in the row ?

A sample would be useful

 

[sobrien1234]

a pivot table may do what you want

EN = date & Race Number
BJ = Horse Rating
?? = Horse itself
?? = Date
?? = Race


Where is the largest Rating , is this BJ you want to find the largest rating for each race and date
Not sure what you mean by


so if you have two horses

Horse AAA
Horse BBB
and they both run
on the same race same day Race number 123
then EN will be
03/03/2018-123

If horse AAA has a rating of 67
and horse BBB has a rating of 88

Not sure what the output is
in the row ?

A sample would be useful

Answer would look as follows:

Column EN Column G Column BJ Column EN
Race123 Horse X 64 88
Race123 Horse Y 88 88
Race123 Horse Z 56 88

and so on. There are 50,000+ lines of data below so need the formula in EN to identify the unique race in EN and then provide the highest number for that race from column BJ. BTW no idea what a pivot table is?!

 

[MARK858]

BTW no idea what a pivot table is?!

Basics of Pivot tables in link below.

http://www.excel-easy.com/data-analysis/pivot-tables.html

Max in link below
Http://www.extendoffice.com/documents/excel/1978-excel-find-max-value-in-a-group.html