ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to search data in one coloumn (https://www.excelbanter.com/excel-worksheet-functions/132643-how-search-data-one-coloumn.html)

gibbs

How to search data in one coloumn
 
Hi all,
My excel file consist of same type of data in various coloumns. I am
searching the data through Ctrl+f function in particular column but i have to
go through the various types of same data in other coloumn before reaching to
destination column.

Is there anyway, whereby i can search the data in particular one column only.

regards
gibbs

Teethless mama

How to search data in one coloumn
 
Select your column ctrl F Find what: "your criteria" Options Search:
select By Columns Find Next

"gibbs" wrote:

Hi all,
My excel file consist of same type of data in various coloumns. I am
searching the data through Ctrl+f function in particular column but i have to
go through the various types of same data in other coloumn before reaching to
destination column.

Is there anyway, whereby i can search the data in particular one column only.

regards
gibbs


[email protected]

How to search data in one coloumn
 
Choose entire column only.



All times are GMT +1. The time now is 02:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com