unknownymous
Board Regular
- Joined
- Sep 19, 2017
- Messages
- 249
- Office Version
- 2016
- Platform
- Windows
Hello Guys,
I have below data that I need to group based on criteria below:
Raw (Sheet1):
<tbody>
</tbody>
End Result:
<tbody>
</tbody>
<tbody>
</tbody>
Basically, I need to group the whole data and separate those with Status note:
Upper Part: "Done", "OK", "Complete"
Bottom Part: "Pending", "Incomplete" and Blank cell
I need to do the same process on 5 more sheets (Sheet2-Sheet6). Note that the range may vary so need to highlight the whole row in separating data and sorted in descending order.
Any help will be much appreciated.
I have below data that I need to group based on criteria below:
Raw (Sheet1):
| ID | Name | Status |
| 01 | Donna | Done |
| 05 | Karl | Complete |
| 06 | Ems | Pending |
| 02 | Shawn | Incomplete |
| 05 | Mae | |
| 03 | Ann | OK |
<tbody>
</tbody>
End Result:
| ID | Name | Status |
| 01 | Donna | Done |
| 03 | Ann | OK |
| 05 | Karl | Compelete |
| ID | Name | Status |
| 02 | Shawn | Incomplete |
| 05 | Mae |
<tbody>
</tbody>
| 06 | Ems | Pending |
<tbody>
</tbody>
Basically, I need to group the whole data and separate those with Status note:
Upper Part: "Done", "OK", "Complete"
Bottom Part: "Pending", "Incomplete" and Blank cell
I need to do the same process on 5 more sheets (Sheet2-Sheet6). Note that the range may vary so need to highlight the whole row in separating data and sorted in descending order.
Any help will be much appreciated.
