+ Reply to Thread
Results 1 to 5 of 5

Need to Find escalation % on Series of Rent data for years in horizontal form

  1. #1
    Registered User
    Join Date
    01-16-2013
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    2

    Need to Find escalation % on Series of Rent data for years in horizontal form

    Hi

    I have an Series of Rent data( ie future rentals only with amount). I need a formula that will scan automatically the series of data put the appropriate escalation % to me

    Escalation % Jan to Dec 2012 USD'000 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Oct-13
    225,000 4.50 19,800 19,800 19,800 19,800 19,800 19,800 19,800 21,780 21,780 21,780
    336,600 6.73 29,700 29,700 29,700 29,700 29,700 29,700 29,700 29,700 29,700 32,075
    336,600 6.73 29,700 29,700 29,700 29,700 29,700 29,700 29,700 29,700 29,700 32,075

  2. #2
    Valued Forum Contributor
    Join Date
    09-04-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    463

    Re: Need to Find escalation % on Series of Rent data for years in horizontal form

    upload a sample file with your manual result

    Regard
    CA Mahaveer Somani

  3. #3
    Registered User
    Join Date
    01-16-2013
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Need to Find escalation % on Series of Rent data for years in horizontal form

    Hi

    I have attached the excel file with yello marking of manual working. Kindly help me with formula
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-05-2023
    Location
    Doha
    MS-Off Ver
    365
    Posts
    3

    Re: Need to Find escalation % on Series of Rent data for years in horizontal form

    Hi

    I assume that this is not solved yet based on the activity in this thread. if someone has a knowledge of solving this would highly appreciate

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Need to Find escalation % on Series of Rent data for years in horizontal form

    After 10 years ? ... I doubt it!
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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