keenasmustard Wrote:
Have been using excel for some years now (self taught) and there are a
few
occasions where things drive me nuts. Usually I sort them out, but this
one has beaten me before and has cropped up again to haunt me.
It goes somthing like this.
I have a column of results of which I can extract the highest result.
No problems there. But I also wish to see if that result is repeated.
Again no
problem there, using "Large". I can locate the first result using
"Match" to find the row,then add one to this to start the search again
from the last result +1.
Ok, still with me. So I have my new range, but do not know how to use
it.
Have looked at many, many web sites and tried nearly all the most
likley
functions in excel. All except the right one. HELP PLEASE.

Keenasmustard


Thanks to those who offered help.
I now have a working solution.

Thanks Again

Keenas


--
keenasmustard
------------------------------------------------------------------------
keenasmustard's Profile: http://www.excelforum.com/member.php...o&userid=31524
View this thread: http://www.excelforum.com/showthread...hreadid=512185