Formula first time numer appears

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mrover - 08 Feb 2008 15:19 GMT

I am trying to get a formula which would put in the top cell what line the
first time a number =>than a number that I want it to look for.
Example
A B C
        3 this is the first line that =>8
1    6
2    7
3    8
4    8
5    6

Reply to this Message

Ron Coderre - 08 Feb 2008 15:27 GMT

Try this:

=MATCH(TRUE,INDEX(A1:A100>=8,0),0)

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

>I am trying to get a formula which would put in the top cell what line the
> first time a number =>than a number that I want it to look for.
[quoted text clipped - 6 lines]
> 4 8
> 5 6

Reply to this Message

Mike H - 08 Feb 2008 15:28 GMT

Hi,

Try this

=MATCH( A1, $B$1:$B$1000,0)

Returns the row number from column B of the value in A1

Mike

> I am trying to get a formula which would put in the top cell what line the
> first time a number =>than a number that I want it to look for.
[quoted text clipped - 6 lines]
> 4 8
> 5 6

Reply to this Message

Mrover - 08 Feb 2008 15:37 GMT

Is there something I can add to give me >=8 what if it is 8.1 or 1000?
Right now it just picks up the first 8. Thank you for the first reply that
was great.

> Hi,
>
[quoted text clipped - 16 lines]
> > 4 8
> > 5 6

Reply to this Message