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