newbie needs help...
 

I have a spreadsheet with 3000 rows. How do I find all of the numbers from
a column that are less than 108 and identify them by row number?

Thanks,
Dave

newbie needs help...
 

Dave,
How do you want the row numbers shown to you? As a list in a separate
sheet, coloured in the list itself, filtered on the screen....... ?

"Dave" wrote:

I have a spreadsheet with 3000 rows. How do I find all of the numbers from
a column that are less than 108 and identify them by row number?

Thanks,
Dave

newbie needs help...
 

Dave,

Assuming data in A1:A3000, select C1:C300, and put this formula in the
formula bar

=SMALL(IF($A$1:$A$3000<108,ROW($A$1:$A$3000),""),R OW($A$1:$A$3000))

and commit it with Ctrl-Shift-Enter. It will list all matching rows, and
than a bunch of #N/As.

--

HTH

RP

"Dave" wrote in message
om...
I have a spreadsheet with 3000 rows. How do I find all of the numbers
from
a column that are less than 108 and identify them by row number?

Thanks,
Dave

newbie needs help...
 

Coloured in the list itself would be fine.

Thanks,
Dave

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

newbie needs help...
 

You will have to do a lot of scrolling.

Select all 3000 cells, use FormatConditional Formatting
Change Condition1 to Formuls Is
Add a formula of =A1<108
On pattern tab select a colour
Exit out

--

HTH

RP

"Dave" wrote in message
...


Coloured in the list itself would be fine.

Thanks,
Dave

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!