+ Reply to Thread
Results 1 to 5 of 5

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

  1. 05-06-2018, 06:59 AM #1
    Robert1311
    Robert1311 is offline
    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
    Reply With QuoteRegister To Reply
  2. 05-06-2018, 11:12 AM #2
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,625

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

    Pl see file
    ARRAY Formulas
    In R2 then drag down.

    =MAX(IF($A$2:$A$35=$K3,10*($C$2:$C$35)+$F$2:$F$35,""))

    IN T2 then drag down

    =MIN(IF($A$2:$A$35=$K3,10*($C$2:$C$35)+$F$2:$F$35,""))

    FOR S & U columns Your formulas are retained
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.
    Reply With QuoteRegister To Reply
  3. 05-06-2018, 02:43 PM #3
    Robert1311
    Robert1311 is offline
    Registered User
    Join Date
    01-28-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    55

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

    Hi kvsrinivasamurthy ,

    Great!! Thanks very much.

    Rgds, Robert
    Reply With QuoteRegister To Reply
  4. 05-06-2018, 03:09 PM #4
    JohnTopley
    JohnTopley is online now
    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,359

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

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Reply With QuoteRegister To Reply
  5. 05-07-2018, 02:06 AM #5
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,625

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

    Thanks for feed back.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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. Arranging year-over-year 3rd quarter sales with all customers listed in only one column.
    By excelsos in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1