Anonnymouse
New Member
- Joined
- Jun 28, 2023
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
Hello MrExcel,
I am wondering if there is a way if cell e has the same vin as any other in cell e it adds the price together and then sorts it in cell h with largest to smallest.
Thanks for the help!
I am wondering if there is a way if cell e has the same vin as any other in cell e it adds the price together and then sorts it in cell h with largest to smallest.
Thanks for the help!
A | B | C | D | E | F | G | H | I | J | K | |
1 | |||||||||||
2 | Order | Auction Price | Description | Doors | VIN | Total | Description | VIN | |||
3 | 12 | 100 | BENZ | 2 | 5050 | 350 | BENZ | 5050 | |||
4 | 134 | 50 | BENZ | 2 | 5050 | 280 | CHEVY | 5020 | |||
5 | 152 | 60 | BENZ | 2 | 5060 | 190 | HONDA | 5070 | |||
6 | 167 | 80 | FORD | 4 | 5010 | 110 | TOYOTA | 5030 | |||
7 | 176 | 150 | CHEVY | 4 | 5020 | 100 | FORD | 5010 | |||
8 | 124 | 20 | FORD | 4 | 5010 | 60 | BENZ | 5060 | |||
9 | 133 | 40 | CHEVY | 4 | 5020 | ||||||
10 | 111 | 90 | CHEVY | 4 | 5020 | ||||||
11 | 108 | 110 | TOYOTA | 4 | 5030 | ||||||
12 | 197 | 190 | HONDA | 4 | 5070 | ||||||
13 | 154 | 200 | BENZ | 2 | 5050 |