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.
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

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

Legend
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!)
 

Watch MrExcel Video

Forum statistics

Threads
1,127,035
Messages
5,622,332
Members
415,894
Latest member
silverhaze

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top