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  ...