| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting Rows based on a number in a field
I have columns L to AZ that may or may not contain the number 41, I need to
extract all of the rows that have the number 41 somewhere in them, and make o seperate files one with and one without rows with 41? Any help would be appreciated Columns A to K have address data, that I hope can be excluded from this as some addresses may have 41, but I can live with manually removing them if I need to. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting specific rows out of one worksheet based on an identifi | Excel Discussion (Misc queries) | |||
| Extracting data from rows where one field is blank | Excel Discussion (Misc queries) | |||
| Extracting rows based on fixed criteria | Excel Discussion (Misc queries) | |||
| Split field based on number of characters and space | Excel Worksheet Functions | |||
| sum multiple rows based on progressing date field on each row | Excel Worksheet Functions | |||
Threaded Mode
