View Single Post
  #2  
Old 29th October 2008, 08:38 AM
Michal Michal is offline
Member
 
Join Date: Oct 2005
Posts: 1,007
Default

Hi ,


Figured it out myself I had to write a little thingy others might like it

Qx = number of selections in top row
Qy = number of selections in second row

TempQcost = 0
QCost = 0

For QCalc = 1 To Qx

TempQcost = 1 * Qy - 1
QCost = QCost + TempQcost
Qy = Qy - 1

Next QCalc

That is it, once the calculation comes out of the loop the Quinella (QCost) is calculated correctly I think.

I also feel quite smart again

Michal
Reply With Quote