newbie needs help...

[Dave]

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

 

[Guest]

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....... ?

 

[Bob Phillips]

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),""),ROW($A$1:$A$3000))

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

 

[Dave]

Coloured in the list itself would be fine.

Thanks,
Dave

 

[Bob Phillips]

You will have to do a lot of scrolling.

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