proficient
Well-known Member
- Joined
- Apr 10, 2012
- Messages
- 745
- Office Version
- 2016
- Platform
- Windows
- Mobile
Assalam-o-alaikum and Hi every one...
What I want is that here is my sample data with desire result, I want to search UNIQUE Job and Wash and then the total qty. for your reference I made a dummy sheet with desire result, on SHEET 1 I have the DATA and on sheet 2 I want the result... is it possible?
Sheet1
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
What I want is that here is my sample data with desire result, I want to search UNIQUE Job and Wash and then the total qty. for your reference I made a dummy sheet with desire result, on SHEET 1 I have the DATA and on sheet 2 I want the result... is it possible?
Sheet1
* | A | B | C | D |
1 | SHEET 1 | * | * | |
2 | Unit | Job # | Wash | Qty |
3 | 1 | 7781 | DK | 1250 |
4 | 1 | 7785 | DK | 1400 |
5 | 3 | 7862 | LT | 1550 |
6 | 2 | 7779 | Blue | 1700 |
7 | 2 | 7797 | Blue | 1850 |
8 | 1 | 7781 | DK | 2000 |
9 | 1 | 7781 | DK | 2150 |
10 | 2 | 7841 | LT | 2300 |
11 | 1 | 7785 | DK | 2450 |
12 | 2 | 7779 | Blue | 2600 |
13 | 2 | 7797 | Blue | 2750 |
14 | 3 | 7862 | LT | 2000 |
15 | 3 | 7797 | LK01 | 4150 |
16 | * | * | * | * |
17 | SHEET 2 | * | * | |
18 | Unit | Job # | Wash | Qty |
19 | 1 | 7781 | DK | 5400 |
20 | 1 | 7785 | DK | 3850 |
21 | 2 | 7779 | Blue | 4300 |
22 | 2 | 7797 | Blue | 4600 |
23 | 2 | 7841 | LT | 2300 |
24 | 3 | 7862 | LT | 3550 |
25 | 3 | 7797 | LK01 | 4150 |
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4