Filter,Sort, or ????

cutiechic316

New Member
Joined
Nov 29, 2009
Messages
2
I've got a spreadsheet and I need to sort it so that I only see the entries that work in either NY or CA (which I've done with a filter) and have sales LESS THAN 4000 OR Assets GREATER THAN 10000 (which I can't figure out). Sales and Assets are two different columns and I can't find a way to show entries as long as they meet one criteria or the other. Please help.
 

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
Hi and welcome to the board!! You can use Advanced Filter!!
See the articles and video's on advance filter at Contextures

lenze
 

cutiechic316

New Member
Joined
Nov 29, 2009
Messages
2
I don't know how to use the advanced filter option, and I didn't understand the instructions on the site.
 

Smitty

MrExcel MVP
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

What part of Advanced Filter didn't you understand?

We're all here to help, so just tell us where you're having a problem. :)

(Happy Thanksgiving Lenze - ICOP!)
 

Forum statistics

Threads
1,084,859
Messages
5,380,324
Members
401,665
Latest member
iahmad

Some videos you may like

This Week's Hot Topics

Top