| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Searching for a "LESS THAN"" amount within a sheet! | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Formula to figure an average on a range of cells with an "if" form | Excel Worksheet Functions | |||
| When I type "13" the spreadsheet shows "14." Possibilities? | Excel Discussion (Misc queries) | |||
| Can I automaticly figure "cost" and sale price in Excel? | Excel Worksheet Functions | |||
Linear Mode
