Extracting Rows based on a number in a field

Y

Yookaroo

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.
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help sorting data 4
How can the font and size of (all) citation numbers be altered? 1
Review this if function please..... 0
Separate name and numbers 6
Sum of two highest numbers 7
Formula that will increase an integer added to a value based on.. 0
How to use a cell value as the ref argument in CELL"contents" form 3
Adding another if statement to an index formula 0

Top