Results 1 to 5 of 5

Determine oldest combi of year and quarter and put related value to cell Hi there

Threaded View

  1. #1
    Registered User
    Join Date
    01-28-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    55

    Determine oldest combi of year and quarter and put related value to cell Hi there

    Hi there, can anyone help me out?
    In a data table (column A-F) I want :
    1. determine what is the oldest recent year/quarter per customer and
    2. copy the year/quarter (YYYQ) and paste it in column N. The value in the cell related to this year/quarter combi must be paste in column O

    In column L the most recent combi is already filled, but i do not succeed how to make the formule for the oldest combi works for the whole range (N3-N5)
    I have attached a file ito make clear what I mean.


    Help is much appreciated!
    Rgds, Robert
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Determine most recent combi of year and quarter and put related value to cell
    By Robert1311 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2018, 03:31 AM
  2. Replies: 4
    Last Post: 08-05-2015, 06:39 PM
  3. [SOLVED] How to sort month and year into oldest to new (A-Z)
    By raysrains in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-03-2014, 09:49 AM
  4. [SOLVED] Counting Number of Cell by Quarter of Year
    By ususim in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-23-2013, 11:38 PM
  5. Input a year to determine the start date for 4-4-5 Calendar Year.
    By mak1176 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-25-2013, 10:34 AM
  6. Determine Date Quarter
    By Tarball in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-31-2010, 01:56 PM
  7. Determine Quarter & Year
    By Kolacube in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-25-2008, 07:02 AM

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