+ Reply to Thread
Results 1 to 4 of 4

Make a list which change in years based on database

  1. #1
    Forum Contributor
    Join Date
    11-10-2012
    Location
    Sweden, Stockholm
    MS-Off Ver
    MS Excel 2010
    Posts
    133

    Make a list which change in years based on database

    There are columns with names that are repeted inconsequntly of times and each time it comes up a number and established year.

    Attached file present what I need.

    I want a list which can continue from years on and depending on a year of the pc it can upgrade each year.
    Bad explanation, though have a look in xls file where I think it gives justice what i need help with.
    Thanks
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    01-07-2013
    Location
    Michigan
    MS-Off Ver
    O365
    Posts
    601

    Re: Make a list which change in years based on database

    See attached. I changed your years to formulas so they will always update. The basic formula, this one in R3, is based on index / match:
    Please Login or Register  to view this content.
    I changed the first and last formulas to look for anything equal to or below the first year, and equal to or above the last year. Is this what you're looking for?

  3. #3
    Forum Contributor
    Join Date
    11-10-2012
    Location
    Sweden, Stockholm
    MS-Off Ver
    MS Excel 2010
    Posts
    133

    Re: Make a list which change in years based on database

    thank you great done

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,370

    Re: Make a list which change in years based on database

    Hi sealpino,

    The best I could do is using a Pivot Table and group by columns. See the attached. No formulas needed.

    Pivot Table Group by Columns.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. List distinct years between two years.
    By jcollett in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-16-2014, 06:06 PM
  2. [SOLVED] Age based on DOB; Accounts for leap years. Years old if >2, Months if <2 years old.
    By sharpmel in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-17-2013, 04:20 PM
  3. How to Make list of Years noted as a date
    By tejvan in forum Excel General
    Replies: 2
    Last Post: 02-16-2011, 06:41 PM
  4. Replies: 3
    Last Post: 02-24-2008, 07:41 PM
  5. Replies: 3
    Last Post: 06-02-2006, 05:55 AM
  6. Change Xcel Amortization from 30 years to 40 years?
    By onroad80 in forum Excel General
    Replies: 1
    Last Post: 11-28-2005, 07:45 PM
  7. How do i change my database to list view
    By m in forum Excel General
    Replies: 1
    Last Post: 05-26-2005, 05:15 PM

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