Excel Activity Comparision

Here I need to compare the data in excel
Ex:

  •  Amount        Reference     Final Amount     
    
  •      5               A123             10
    
  •      2               A123             10
    
  •      3               A123             10
    
  •      4               A123             10
    
  •      11             A234             12
    
  •      3               A234             12
    
  •      4               A561              4
    

From the above table, I should get the sum of the amount column for the same reference no and compare it with the final amount column (here in a final amount the sum is not done) if there is any difference I should get the msg.

Hi @ram_charan1,

Try pivoting the data on two columns reference number and the amount, then you will easily get the sum of amount for each reference number. It will be easy to compare then