I have a sorted column of prices. How can I program Excel to find the
location of the cell where the price starts to be less than one dollar, i.e.
1.00? As an example, I can't ask it to find say 0.99 as it may also find
12.99 for instance. This is part of a program. Thanks for any help.

Sony

In the name box (to the left of the formula bar) or Edit-goto box (F5
chortcut) type:

index(a:a,match(true,a1:a1000<12.99,0))

or adjust range for other selection. Choose tools-macro-record new
macro before this to include code.



Sony wrote:

I have a sorted column of prices. How can I program Excel to find the
location of the cell where the price starts to be less than one dollar, i.e.
1.00? As an example, I can't ask it to find say 0.99 as it may also find
12.99 for instance. This is part of a program. Thanks for any help.

Sony

Thanks Lori. That was great. It works.

"Lori" wrote in message
oups.com...
In the name box (to the left of the formula bar) or Edit-goto box (F5
chortcut) type:

index(a:a,match(true,a1:a1000<12.99,0))

or adjust range for other selection. Choose tools-macro-record new
macro before this to include code.



Sony wrote:

I have a sorted column of prices. How can I program Excel to find the
location of the cell where the price starts to be less than one dollar,
i.e.
1.00? As an example, I can't ask it to find say 0.99 as it may also
find
12.99 for instance. This is part of a program. Thanks for any help.

Sony