| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
number finding
how to find certain numbers in columns that are in different rows
-- John Roberts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
number finding
Use AutoFilter.
Say we want to find 13 in column A. Click on A1 and pull-down: Data Filter AutoFilter and then select 13 Only those rows containing 13 in column A will be displayed. -- Gary''s Student - gsnu200855 "John Roberts" wrote: how to find certain numbers in columns that are in different rows -- John Roberts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
number finding
Hi,
click Ctrl F and enter the number you are looking for then press find next, other option is to filter the column by that number so all the rows with that number will show up if this helps please click yes, thanks "John Roberts" wrote: how to find certain numbers in columns that are in different rows -- John Roberts |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding first number in a row | Excel Worksheet Functions | |||
| Finding number less than 1 | Excel Discussion (Misc queries) | |||
| finding a number and the number of times it occurs | Excel Discussion (Misc queries) | |||
| finding the right number | Excel Worksheet Functions | |||
| finding row number? | Excel Discussion (Misc queries) | |||
Linear Mode
