sorting

  • Thread starter Thread starter kkondrat1
  • Start date Start date
K

kkondrat1

ID #...................State....................Amount
12.......................AK........................$55,000
3.........................NJ.........................$26,000
4.........................AR.........................$43,000
2.........................DE.........................$32,000
5..........................DE.........................$27,000
23..........................DE.........................$150,000
24.........................AK..........................$250,000

I was using an advanced filter to do this, but it took too long....

any ideas?

criteria:

# states that fall into this range:

<75,000
75,000 -100,000
100,001 -125,000
125,001 - 150,000
150,001 - 175,001
175,001 - 200,000
200,000
Click to expand...

have the end result look like this:

State Name: AK.............#
<75,000.........................1
75,000 -100,000............0
100,001 -125,000..........0
125,001 - 150,000.........0
150,001 - 175,001.........0
175,001 - 200,000.........0
 
Back
Top