29th May 2011, 02:22 PM
|
|
Member
|
|
Join Date: Oct 2005
Posts: 245
|
|
Hi all. I'll try and upload a sample of the main part of my spreadsheet here now, it has most of my formulas, you'll probably think its all over the place. The right hand side wont show all my look up "times", they are now up to around 1700 of these. It's basically the G column that is the issue here. As when the data from Unitab is pasted it doesnt differentiate between a winning margin and a losing margin, but we've discussed this already.
Stugots, I tried your theory again but when I copied and pasted "special/text" all the entries come up with the same cell/s, so to speak.
I've pretty much worked out a way around this dilemna, just means each race takes just a couple of minutes longer.
And Shaun, I still havent spent any time on your other sample yet, just been flat out with other things at present, but I will,..!
Thanks again, Paul
|