Calculating differences for different companies under each other

Hi,

I'm writing my thesis and I have a bunch of data about listed companies.

Attachment 781333

The data consists of quarterly leverage ratios (LV ratio). I want to calculate the change in leverage ratio (LV change). To do this, I subtract each cell with the cell above it. In the example, you can see two different companies, ASM and British American Tobacco. I do not want to subtract the leverage ratio of British American Tobacco with the ASM's one (Row 85). Is there a way to tell Excel to only subtract the values of a certain company with each other and do this for every company separately? I can't do it manually because I have 29.000 rows.

I found it difficult to explain it so I hope it's clear enough.

Thanks

Read reaction #3. I duplicated the respond.

Exclude your not wanted data with formula's in your original list.

After that you can use the pivot table to analyse the data.

Exclude your not wanted data with formula's in your original list.

After that you can use the pivot table to analyse the data.

It will help the forummembers if you add an excel file, without personal data.

I get this respond if I try your file in your original post.

"vBulletin Message
Invalid Attachment specified. If you followed a valid link, please notify the administrator"

Please post an excel file (correctly).

Put this formula in D2 and fill down. This assumes that your data is grouped by company and sorted by date within company, as in the example.

Formula:

Please Login or Register  to view this content.

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking addreputationiconsmall.jpg below their name.