Hi All:
I was wondering if anyone knew how you can extract the top three records from a database without using pivot tables. What I want to do is display the two records that contain the highest dollar amounts.
Here is the database:
Here is the desired result:
Any help you could provide would be much appreciated.
BA
I was wondering if anyone knew how you can extract the top three records from a database without using pivot tables. What I want to do is display the two records that contain the highest dollar amounts.
Here is the database:
Book2 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
3 | Account | Name | Dollars | |||
4 | 500000 | John | 500 | |||
5 | 500050 | Dave | 100 | |||
6 | 500100 | Mike | 200 | |||
7 | 500150 | Steve | 100 | |||
8 | 500200 | Kay | 150 | |||
9 | 500250 | Harry | 600 | |||
Sheet1 |
Here is the desired result:
Book2 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
12 | Account | Name | Dollars | |||
13 | 500250 | Harry | 600 | |||
14 | 500000 | John | 500 | |||
Sheet1 |
Any help you could provide would be much appreciated.
BA