Josh_Hawthorn
New Member
- Joined
- Oct 10, 2017
- Messages
- 2
Hi.
I would really appreciate some help with the below.
Column A is the order number, B is the status of the indvidual line, C reflects B numerically with a "1" for complete and "0" for incomplete.
If A1 = A2 then D is blank, if there is a difference then the completion % is displayed.
I would like column E to show the max value of column D for each value shown in column A.
For example E1:E3 would each show a value of 33%.
<tbody>
</tbody>
Any help with this would be amazing!! Thanks!
I would really appreciate some help with the below.
Column A is the order number, B is the status of the indvidual line, C reflects B numerically with a "1" for complete and "0" for incomplete.
If A1 = A2 then D is blank, if there is a difference then the completion % is displayed.
I would like column E to show the max value of column D for each value shown in column A.
For example E1:E3 would each show a value of 33%.
A | B | C | D | E |
1 | Incomplete | 0 | ||
1 | Incomplete | 0 | ||
1 | Complete | 1 | 33% | |
2 | Complete | 1 | ||
2 | Incomplete | 0 | 50% | |
3 | Complete | 1 | ||
3 | Complete | 1 | ||
3 | Complete | 1 | ||
3 | Complete | 1 | 100% |
<tbody>
</tbody>
Any help with this would be amazing!! Thanks!