Searching for a "LESS THAN" figure within a spreadsheet
 

How can I use the FIND command (or any other) to find all numbers within a
single column that are less than, say 29, on a single sheet?

Thank you,

FLKulchar

Searching for a "LESS THAN" figure within a spreadsheet
 

How about datafilterautofilterfilter on the desired column for your
desires

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"FLKULCHAR" wrote in message
...
How can I use the FIND command (or any other) to find all numbers within a
single column that are less than, say 29, on a single sheet?

Thank you,

FLKulchar

Searching for a "LESS THAN" figure within a spreadsheet
 

Use AutoFilter

Say A1 thru A40 contain:

qwerty
31
39
46
17
30
29
21
23
43
26
19
2
49
5
26
30
1
35
49
30
48
16
32
38
48
44
36
3
3
27
44
46
14
21
1
23
1
39
10

Click on A1 and:
Data Filter AutoFilter Custom Is less than 29

We now see:

qwerty
17
21
23
26
19
2
5
26
1
16
3
3
27
14
21
1
23
1
10

--
Gary''s Student - gsnu201001


"FLKULCHAR" wrote:

How can I use the FIND command (or any other) to find all numbers within a
single column that are less than, say 29, on a single sheet?

Thank you,

FLKulchar

Searching for a "LESS THAN" figure within a spreadsheet
 

Thank you very, very much! I find it amazing what I have yet to learn in
EXCEL!

FLKulchar
"Don Guillett" wrote in message
...
How about datafilterautofilterfilter on the desired column for your
desires

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"FLKULCHAR" wrote in message
...
How can I use the FIND command (or any other) to find all numbers within
a
single column that are less than, say 29, on a single sheet?

Thank you,

FLKulchar

Searching for a "LESS THAN" figure within a spreadsheet
 

Thank you very much; I am amazed as to what I have to learn in EXCEL!

FLKulchar


"Gary''s Student" wrote in message
...
Use AutoFilter

Say A1 thru A40 contain:

qwerty
31
39
46
17
30
29
21
23
43
26
19
2
49
5
26
30
1
35
49
30
48
16
32
38
48
44
36
3
3
27
44
46
14
21
1
23
1
39
10

Click on A1 and:
Data Filter AutoFilter Custom Is less than 29

We now see:

qwerty
17
21
23
26
19
2
5
26
1
16
3
3
27
14
21
1
23
1
10

--
Gary''s Student - gsnu201001


"FLKULCHAR" wrote:

How can I use the FIND command (or any other) to find all numbers within
a
single column that are less than, say 29, on a single sheet?

Thank you,

FLKulchar