Aug 06 2020 04:54 AM
Hi could you please help me with formula for below data-
Doc Number | Line Item | Doc Max |
ER12345 | 5 | |
ER12345 | 6 | ER12345 |
ER12345 | 3 | |
ER12345 | 4 | |
ER12345 | 1 | |
ER12345 | 2 | |
ER23456 | 1 | |
ER23456 | 3 | ER23456 |
ER23456 | 2 | |
ER34567 | 2 | |
ER34567 | 3 | |
ER34567 | 4 | ER34567 |
ER34567 | 1 |
document number should be updated in front of Max number line item (doc max row column) as shown in the above data could you please help me with the formula
Aug 08 2020 04:19 AM
@vijaymestha , here are a couple of variations to @Ramiz_Assaf 's solution if you don't have the Dynamic Array version of Excel.