In the below attached excel file. If vend name is the same from the ‘G’ column then Invc amnt should be added together. the total amount should be added into next column like Vend Total.
The first attached image is the original file. The output should be like second attached image.
Thanks in advance