| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to search data in one coloumn
Choose entire column only.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i add up every other coloumn in a linked sheet | Excel Worksheet Functions | |||
| Merging data looking up (Account) numbers in a coloumn | Excel Worksheet Functions | |||
| Replace Null value in Coloumn | Excel Discussion (Misc queries) | |||
| 2 Question: Coloumn width, Filename | Excel Worksheet Functions | |||
| about coloumn wide | New Users to Excel | |||
Linear Mode
