I need to get unique value of Suppliers based on the different columns
Input:
<tbody>
</tbody>
Output:
<tbody>
</tbody>
Condition for output :
A = Function (Specific), B = Unqiue, C = different, D = date
For Example : Suppliers unique count when 'Function' is 'Operations' , 'Sites' are different and 'Due Date' as per the column header (2019+, 2018, 2017-, #N/A to be mapped under Not Known.
Input:
Functions | Suppliers | Sites | Due Date |
Operations | Apple | #N/A | #N/A |
Operations | Orange | #N/A | 4/13/2020 |
End User Services | Watermelon | #N/A | #N/A |
Operations | Pineapple | #N/A | #N/A |
Operations | Kiwi | Mulgrave | 4/13/2018 |
Research | Fig | Mulgrave | 4/13/2018 |
Research | Kiwi | Mulgrave | 4/13/2018 |
Research | Kiwi | California | 4/13/2018 |
Research | Kiwi | California | 4/13/2018 |
Research | Banana | #N/A | 3/30/2012 |
Operations | Pear | NA | 9/15/2019 |
Software Services | Berry | Sydney | #N/A |
Software Services | Berry | Sydney | 7/9/2018 |
Software Services | Grape | Sydney | 7/9/2018 |
Software Services | Berry | Arizona | #N/A |
Software Services | Berry | Arizona | 12/12/2017 |
<tbody>
</tbody>
Output:
2019+ | 2018 | 2017- | Not known | |
Unique Suppliers |
<tbody>
</tbody>
Condition for output :
A = Function (Specific), B = Unqiue, C = different, D = date
For Example : Suppliers unique count when 'Function' is 'Operations' , 'Sites' are different and 'Due Date' as per the column header (2019+, 2018, 2017-, #N/A to be mapped under Not Known.
Last edited: