makvisions
New Member
- Joined
- Nov 18, 2014
- Messages
- 40
Hello,
I have an excel file with approx. 800 customers in column a, column b is the month it represent, column c is monthly expense
now I want to populate a separate sheet with Top 10 customers in column a and corresponding expense in column b
Below is the sample data, help is appreciated.
<tbody>
</tbody><colgroup><col><col><col></colgroup>
I have an excel file with approx. 800 customers in column a, column b is the month it represent, column c is monthly expense
now I want to populate a separate sheet with Top 10 customers in column a and corresponding expense in column b
Below is the sample data, help is appreciated.
Sr. # | Customer | Expense Total |
1 | Customer 1 | $48 |
2 | Customer 2 | $5,250 |
3 | Customer 3 | $1,732 |
4 | Customer 4 | $36,157 |
5 | Customer 5 | $12,479 |
6 | Customer 6 | $4,828 |
7 | Customer 7 | $899 |
8 | Customer 8 | $11,718 |
9 | Customer 9 | $857 |
10 | Customer 10 | $26,749 |
795 | Customer 795 | $16,962 |
<tbody>
</tbody><colgroup><col><col><col></colgroup>