Check and match the column and do addition if row is similar

I have a list of receipt in excel sheet. How can I check column consecutive receipt with column current receipt. If the receipt match and type of fruits purchased match, add the number of fruits purchased together else leave it be.


Is it always one kind of fruit for each row?

No, Sometime Orange or Grape will come along with apple. But Orange and Grape will not come together.

Hi,
Please check this out,
Is this What you want?


output

Project File
Merge Colum.zip (10.5 KB)

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.