Re: Rotor gauge ranking


Thanks.

My comments were based on your solution Max, but were directed at
anyone. I have got the spreadsheet to do what I want but it is a little
ugly. I have used the original formula you gave to index the allowable
strains for each gauge position at the particular mode and stage on the
same row (I have created some dummy/workings columns to the right that
are out of the way) and then used RANK to rank the given gauge against
these three values, this value goes into another 'dummy/workings'
column. I have than used an if statement to get a column to say what I
what e.g. best, worst etc based on this ranking.


--
Turnipboy
------------------------------------------------------------------------
Turnipboy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24527
View this thread: http://www.excelforum.com/showthread.php?threadid=496362

.