Forum Discussion
Excel Formula
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
2 Replies
vijaymestha , here are a couple of variations to Ramiz_Assaf 's solution if you don't have the Dynamic Array version of Excel.
