Results 1 to 8 of 8

Calculating differences for different companies under each other

Threaded View

  1. #1
    Registered User
    Join Date
    05-22-2022
    Location
    Netherlands
    MS-Off Ver
    365
    Posts
    6

    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
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by JuanVan12; 05-22-2022 at 12:40 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Companies House DISSOLVED Companies.
    By MacStokes in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-24-2017, 02:10 PM
  2. Companies House API - search for companies, populate spreadsheet.
    By damnation in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-19-2016, 10:52 AM
  3. Replies: 14
    Last Post: 07-28-2013, 10:44 AM
  4. calculating differences
    By bluesky in forum Excel General
    Replies: 2
    Last Post: 04-16-2009, 11:06 PM
  5. Calculating time differences
    By cjccpa in forum Excel General
    Replies: 5
    Last Post: 04-01-2008, 09:02 AM
  6. Calculating time differences
    By WaySlowWhitey in forum Excel General
    Replies: 3
    Last Post: 10-22-2007, 10:26 AM
  7. Calculating Differences Uniformly
    By tx12345 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-30-2005, 11:49 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1