number finding
 

how to find certain numbers in columns that are in different rows
--
John Roberts

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

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