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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting Rows based on a number in a field
You can do this using a temporary column.
Assuming your data starts in Row1. In cell BA1 enter the formula =COUNTIF(L1:AZ1,41) This will give you the count of 41's. Copy the formula down as required. Sort the data with this column..move the data with 0's to a different sheet. If you have text values instead of numerics then =COUNTIF(L1:AZ1,"*41*") If this post helps click Yes --------------- Jacob Skaria "Yookaroo" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting Rows based on a number in a field
Excel 2007
Advanced Filter Manual or Macro. No formulas. http://www.mediafire.com/file/4uomomvuolw/06_26_09.xlsm |
Reply |
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 |