Remove Row with Earlier Values in List

[Bob1955]

I have a list of horses and odds. As the odds of a horse are updated the price is added to the bottom of the list. eg. B2 and B12 in the sheet attached as well as B3 and B 13 etc.

I am chasing a process that will remove the upper most row eg. row 2 and keep row 12 - remove row 3 and keep row 13 and so on.

Any help appreciated.

Bob

[AlphaFrog]

When the odds are updated, does it include a date\time? If yes, you could sort on the date-time column so the newest are at the top. Then use Advanced Filter to filter for unique values (horses). It would keep the top most unique horse and it would be the latest odds because you previously sorted on date-time.

[Bob1955]

Thanks AlphaFrog.

Unfortunately the data does not include date and time.

However I am trying the formula below to set up a TRUE/FALSE column.

=ISNONTEXT(IF(B2<>B3,COUNTIF($B$2:B2,B2),""))

Thanks for helping.

[Croweater]

Or you could try something like this code..

Please Login or Register  to view this content.