Link to home
Start Free TrialLog in
Avatar of al4629740
al4629740Flag for United States of America

asked on

finding data on my excel sheet

I have a column named Asset Code and NTEE Code in my Excel Sheet.

I need to find all records that have an asset code of 5 or higher.   In addition all the records must contain the string R20 in the NTEE Code column  Is there a way to do this?
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of al4629740

ASKER

Is there a way to save the filter and put on other excel sheets?
No points for this

You can copy this filtered list and paste it elsewhere, if that is what you meant.
did you attach something?  I didn't see it
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I think I have to sign up for something.  It may be too much trouble to do this.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial