15th May 2009, 01:06 PM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 1,096
|
|
Quote:
|
Originally Posted by lomaca
There is no simple formula, you will have to write a VBA script to loop through all the lines, select the course AND the race number starting from race one and then sort that group by price. If you use a select statement you can include the sort function into it.
You will need a double loop, first for the course, and an inner loop for the race number.
I haven't used VBA for many years, so I cant help you with that, the closest I can come with is VB which is similar, but I think someone out there is an Excel guru and will be faster, Chrome P maybe?
|
On second thoughts, I suppose you could put a formula in a new column, that would compare the course and race number in the following record and until they are the same it would write the price in a cell if it is less then the cell before.
But you would have to make the comparison for the course and when the course name changes assign a new cell to write the smallest price into. It's a round-about way of what I said before, it might even work?
|