software

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 quot;Largequot;. I can locate the first result using
quot;Matchquot; 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--
keenasmustard
------------------------------------------------------------------------
keenasmustard's Profile: www.excelforum.com/member.php...oamp;userid=31524
View this thread: www.excelforum.com/showthread...hreadid=512185I'm not sure what you want to do? Do you want to know how many times your
maximum value is listed in a column?

Let's say your data is in column A (for this example)
Use this to find the # times the max is listed in column A.
=COUNTIF(A:A,LARGE(A:A,1))

Just make sure you don't put it in column A or you'll have a circular
reference.

quot;keenasmustardquot; gt;
wrote in message
news:keenasmustard.237v7e_1139916003.307@excelforu m-nospam.com...
gt;
gt; Have been using excel for some years now (self taught) and there are a
gt; few
gt; occasions where things drive me nuts. Usually I sort them out, but this
gt; one has beaten me before and has cropped up again to haunt me.
gt; It goes somthing like this.
gt; I have a column of results of which I can extract the highest result.
gt; No problems there. But I also wish to see if that result is repeated.
gt; Again no
gt; problem there, using quot;Largequot;. I can locate the first result using
gt; quot;Matchquot; to find the row,then add one to this to start the search again
gt; from the last result 1.
gt; Ok, still with me. So I have my new range, but do not know how to use
gt; it.
gt; Have looked at many, many web sites and tried nearly all the most
gt; likley
gt; functions in excel. All except the right one. HELP PLEASE.
gt;
gt; Keenasmustard
gt;
gt;
gt; --
gt; keenasmustard
gt; ------------------------------------------------------------------------
gt; keenasmustard's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31524
gt; View this thread: www.excelforum.com/showthread...hreadid=512185
gt;
you haven't really been clear about what your problem is - is it how to
define the second range, or how to find the maximum?

from what you've said, to see if the maximum is repeated, just do a
count on the maximum, e.g.

=COUNTIF(A1:A23,MAX(A1:A23))

where your range is A1:A23.Assuming that the lookup range is A1:A100, and the first match row is stored
in C1, use

=MATCH(MAX($A$1:$A$100),OFFSET($A$1,C1,0,100-C1,1),0) C1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;keenasmustardquot; gt;
wrote in message
news:keenasmustard.237v7e_1139916003.307@excelforu m-nospam.com...
gt;
gt; Have been using excel for some years now (self taught) and there are a
gt; few
gt; occasions where things drive me nuts. Usually I sort them out, but this
gt; one has beaten me before and has cropped up again to haunt me.
gt; It goes somthing like this.
gt; I have a column of results of which I can extract the highest result.
gt; No problems there. But I also wish to see if that result is repeated.
gt; Again no
gt; problem there, using quot;Largequot;. I can locate the first result using
gt; quot;Matchquot; to find the row,then add one to this to start the search again
gt; from the last result 1.
gt; Ok, still with me. So I have my new range, but do not know how to use
gt; it.
gt; Have looked at many, many web sites and tried nearly all the most
gt; likley
gt; functions in excel. All except the right one. HELP PLEASE.
gt;
gt; Keenasmustard
gt;
gt;
gt; --
gt; keenasmustard
gt; ------------------------------------------------------------------------
gt; keenasmustard's Profile:
www.excelforum.com/member.php...oamp;userid=31524
gt; View this thread: www.excelforum.com/showthread...hreadid=512185
gt;

Rob Hick Wrote:
gt; you haven't really been clear about what your problem is - is it how to
gt; define the second range, or how to find the maximum?
gt;
gt; from what you've said, to see if the maximum is repeated, just do a
gt; count on the maximum, e.g.
gt;
gt; =COUNTIF(A1:A23,MAX(A1:A23))
gt;
gt; where your range is A1:A23.Rob

Thanks for your reply.
I have the quot;countifquot; part sorted.
What I need to do is search my column for the position of the second
occurance of the number.
Have got to the part where I have the new range to search, but don't
know how to get quot;Matchquot; to pick up on the cell that has my range
address listed.

keenas--
keenasmustard
------------------------------------------------------------------------
keenasmustard's Profile: www.excelforum.com/member.php...oamp;userid=31524
View this thread: www.excelforum.com/showthread...hreadid=512185
Bob Phillips Wrote:
gt; Assuming that the lookup range is A1:A100, and the first match row is
gt; stored
gt; in C1, use
gt;
gt; =MATCH(MAX($A$1:$A$100),OFFSET($A$1,C1,0,100-C1,1),0) C1
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;keenasmustardquot;
gt; gt;
gt; wrote in message
gt; news:keenasmustard.237v7e_1139916003.307@excelforu m-nospam.com...
gt; gt;
gt; gt; Have been using excel for some years now (self taught) and there are
gt; a
gt; gt; few
gt; gt; occasions where things drive me nuts. Usually I sort them out, but
gt; this
gt; gt; one has beaten me before and has cropped up again to haunt me.
gt; gt; It goes somthing like this.
gt; gt; I have a column of results of which I can extract the highest
gt; result.
gt; gt; No problems there. But I also wish to see if that result is
gt; repeated.
gt; gt; Again no
gt; gt; problem there, using quot;Largequot;. I can locate the first result using
gt; gt; quot;Matchquot; to find the row,then add one to this to start the search
gt; again
gt; gt; from the last result 1.
gt; gt; Ok, still with me. So I have my new range, but do not know how to
gt; use
gt; gt; it.
gt; gt; Have looked at many, many web sites and tried nearly all the most
gt; gt; likley
gt; gt; functions in excel. All except the right one. HELP PLEASE.
gt; gt;
gt; gt; Keenasmustard
gt; gt;
gt; gt;
gt; gt; --
gt; gt; keenasmustard
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; keenasmustard's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31524
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=512185
gt; gt;
Bob

Thank you so much.
Its so simple when you see it

Regards
keenasmustard--
keenasmustard
------------------------------------------------------------------------
keenasmustard's Profile: www.excelforum.com/member.php...oamp;userid=31524
View this thread: www.excelforum.com/showthread...hreadid=512185
keenasmustard Wrote:
gt; Have been using excel for some years now (self taught) and there are a
gt; few
gt; occasions where things drive me nuts. Usually I sort them out, but this
gt; one has beaten me before and has cropped up again to haunt me.
gt; It goes somthing like this.
gt; I have a column of results of which I can extract the highest result.
gt; No problems there. But I also wish to see if that result is repeated.
gt; Again no
gt; problem there, using quot;Largequot;. I can locate the first result using
gt; quot;Matchquot; to find the row,then add one to this to start the search again
gt; from the last result 1.
gt; Ok, still with me. So I have my new range, but do not know how to use
gt; it.
gt; Have looked at many, many web sites and tried nearly all the most
gt; likley
gt; functions in excel. All except the right one. HELP PLEASE.
gt;
gt; KeenasmustardThanks to those who offered help.
I now have a working solution.

Thanks Again

Keenas--
keenasmustard
------------------------------------------------------------------------
keenasmustard's Profile: www.excelforum.com/member.php...oamp;userid=31524
View this thread: www.excelforum.com/showthread...hreadid=512185