RE: CDI gr8flyer55
Jack,
Ilook at the excel file , Last Rev3 ,I had a bit time today and in the Table value on the D3 for copy paste I look at the statement and reason for starting with the high number and then small is
that it gets first cell G262 and then G7,G8....etc.
I change the beginning and the end of the statement and then all comes in order. Un less you need the G262 for some reason to be first. .
G262= 916RPM
As far as calculation all seams to be OK, I test it with a linear curve like in the last posting and all comes in order .
If you make a wave curve then numbers are up and down to reflect that.
Before:
=TEXT(G262,0)&","&TEXT(G7,0)&","&T EXT(G8,0)&","&TEXT(G9,0)&",........... ....,"&TEXT('Table Values'!G261,0)
After:
=TEXT(G7,0)&","&TEXT(G8,0)&","&TEX T(G9,0)&",..........,"TEXT(G261,0)&","& ;TEXT('Table Values'!G262,0)
Thanks
Adrian