finding numbers in excel
 

I have several columns of numerical values, but over 1000 rows.
Within the 1000+ rows, there is about 800 consecutive rows that I am
interested in. I am interested in the values between when the
numerical value goes below (starting row) a certain threshold and then
go back above (ending row) this threshold (lets just say 5 for
example). However, this changes with each column, but the threshold
value remains the same. Therefore, I would like to find the starting
row and ending row of the values of interest. So if I have the
following:

7
9
6
3
4
1
8

I would like to find row4 (where 3 value is located) and row6 (where 1
value is located). Is this possible in Excel? I was thinking of an
if statement, but don't think that would work here. Anything to
return the actual row value?

finding numbers in excel
 

Try conditional formatting to light them up.
Depending on your Excel version (03 or 07), many different options are
available.

Try Help / F1 and I think you'll find what you are looking for.

--
Regards;
Mark Rosenkrantz
--
Spreadsheet Solutions
Uithoorn
Netherlands (Those who live some 18 feet below sea level)
--
E:
W: www.spreadsheetsolutions.nl
--
"ms" wrote in message
...
I have several columns of numerical values, but over 1000 rows.
Within the 1000+ rows, there is about 800 consecutive rows that I am
interested in. I am interested in the values between when the
numerical value goes below (starting row) a certain threshold and then
go back above (ending row) this threshold (lets just say 5 for
example). However, this changes with each column, but the threshold
value remains the same. Therefore, I would like to find the starting
row and ending row of the values of interest. So if I have the
following:

7
9
6
3
4
1
8

I would like to find row4 (where 3 value is located) and row6 (where 1
value is located). Is this possible in Excel? I was thinking of an
if statement, but don't think that would work here. Anything to
return the actual row value?