| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to search for a word and put that entire row in a list
I have a column which contains the word "Contracted" and all corresponding
columns have data which I want to put into another worksheet. I want to creat a function that allows me to search for only the rows which contain the word Contracted and then formats the adjacent columns data after that. I have probably 3000 rows that it will need to search through putting all the data in the columns one after another. Tracy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to search for given term, and if not found in column to add it to list | Excel Worksheet Functions | |||
| Getting Excel whilst using the sumif formula to search for part of a word | Excel Discussion (Misc queries) | |||
| need formula to search column for a word and return another word | Excel Discussion (Misc queries) | |||
| Search Entire Workbook | Excel Discussion (Misc queries) | |||
| How to Search for word in the Entire Workbook | Excel Discussion (Misc queries) | |||
Threaded Mode
