Originally Posted by
BCB
Hello
I have some dizzyingly long rows, wherein each cell has its "Bigger than.."-results of their respective columns above.
In order to localize the greatest (and second biggest, and third, etc) value of each row at a glance, I've decided to spend an additional row underneath each of these rows, in which only the cell under the greatest value will manifest itself (preferably with the value), while the rest of them stay blank.
Well, not quite: the problem arises when I want a formula to perform likewise, when also regarding the second largest value, and the third largest, and so on - in the same row.
I solved the first problem, in a combination of suggestions from both the Help-program and some of you tipsters here.
=IF(CV92=3453;CV92*1;"")
The number 3453 is the f9(frozen) result of a "Greatest value" formula, ranging from, say, CN92 to EV92.
This could surely be replaced by a "Second largest"-formula, and this one in its turn by a "third largest" and so on.
The problem with this solution, is that the latest variation would erase the results of the former formula (the greater value), if copied along in one move.
The ideal formula would not only present the greater, but also the succeeding values of request as they appear along the row.
That would save a lot of time, and quite a little space in my worksheets.
Any suggestions?
Thanks in advance.
bcb
Bookmarks