Hello!

I have a spreadsheet that needs to be first sorted by state (acending) and account current balance (I do by smallest to largest) - I Can do This

THEN

randomized which I do by =rand()*1000

THEN

sorted by a total balance amount, for example I may need to extract accounts that TOTAL $1500 together. This is the part that I need help on.

See example below.

This would be a sample spreadsheet

State Balance
NY 350
NJ 750
CA 250
MA 15
IL 75
WA 35
TX 40

I would need to end up with three spreadsheets
1. the orginial spreadsheet ( as in the data above)
2. the spreadsheet showing the accounts that total up to $1500
3. the spreadsheet showing the accounts that are NOT in spreadsheet #2


Thank you for all your help