Filtering and Find difference

[webmax]

Hi

I have the data in the above of the sheet. If i filter the Name as A then it will shows the Difference between Feb14 - Jan 14 (subtraction) and Difference Mar 14 - Feb 14.

If i select the Name B then it will shows the difference of Feb 14 - Jan 14 of B and so on.

I am attaching the sample for your reference

 

[bobhc]

And you require what help!!!!!!

 

[webmax]

if i filter with name the below table will automatically change

 

[NARAYANK991]

Hi Shahul ,

See if this helps.

Narayan

 

[webmax]

Sir

The Formula is correct but if the name is huge for example 2000k names how to put the values.

 

[NARAYANK991]

Hi Shahul ,

I cannot help if the sample workbook is not representative of your real-life working data.

If you can upload some realistic data , do so.

Narayan