Link to home
Create AccountLog 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
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
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
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
I think I have to sign up for something.  It may be too much trouble to do this.
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account