Hi,

At the moment, my account number only is able to show next to my total amount. However, I want the account number is able to show next to each invoice number. Is it any excel formula can help to do this ?

Invoice Number Amount
123 $360.00
Account 10069 $360.00

456 $480.00
789 $390.00
444 $770.00
Account 10070 $1,640.00


99 $30.00
10 $40.00
Account 10090 $70.00

Thanks in advance !