+ Reply to Thread
Results 1 to 11 of 11

How can I extract unique months from one column to an another column?

  1. #1
    Forum Contributor
    Join Date
    11-26-2014
    Location
    Bosnia&Herzegovina
    MS-Off Ver
    Office2013
    Posts
    281

    Question How can I extract unique months from one column to an another column?

    Hi,
    please help,
    How to extract unique values from A column to G column and group by month only using formulae(array)?

    I have A1 which is DATE, B1 is DRIVER, C1 Quantity.
    Let's say in A2:A10 are random dates between October to December 2023(there may be blank cells), in G2:G4 i want results Oct.23,Nov.23 and Dec.23, this formula isn't working:
    Please Login or Register  to view this content.
    I'm from EU, ; separator and still using Office2013.

    Thanks in advance as always, God Bless

  2. #2
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: How can I extract unique months from one column to an another column?

    For extracting unique values in Excel 2013 you can go to Data and press Remove Duplicates button.

    Remove Duplicates

  3. #3
    Forum Contributor
    Join Date
    11-26-2014
    Location
    Bosnia&Herzegovina
    MS-Off Ver
    Office2013
    Posts
    281

    Re: How can I extract unique months from one column to an another column?

    I need formula, not pivot table, no anything else, my colleague is Excel novice.
    Need to summarize quantity for each unique Driver, columns group by Month and rows values are sum of Quantity

    There may be two people with the same name, there will be licence plate and name to distinct two driver w/ the same name. Unique driver name(and dups, two or more same name different licence plate) in one column, other column are Months, sum of Quantity vaules for each name are in rows,
    Last edited by B.W.B.; 01-14-2024 at 08:57 AM. Reason: Adding some and spelling corr

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: How can I extract unique months from one column to an another column?

    Pl read yellow banner on top of this page.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  5. #5
    Forum Contributor
    Join Date
    11-26-2014
    Location
    Bosnia&Herzegovina
    MS-Off Ver
    Office2013
    Posts
    281

    Re: How can I extract unique months from one column to an another column?

    Sorry, here's a file
    Attached Files Attached Files

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: How can I extract unique months from one column to an another column?

    Please remember that EXPECTED answers are far more useful than ??? or non-working formulae.

    Each shaded area = new formula. In the absence of expected answers, this was a guess.

    Check for the {} around the formulae. Some of these may be array formulae in your older Excel product.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  7. #7
    Forum Contributor
    Join Date
    11-26-2014
    Location
    Bosnia&Herzegovina
    MS-Off Ver
    Office2013
    Posts
    281

    Re: How can I extract unique months from one column to an another column?

    THANK YOU MR.GLENN, you're THE BEST.

    In blue area i need sum of D(Quantity) for each Driver, for Month in that column. There(C col) can be a guy with same name but diff lic.plate,
    Last edited by B.W.B.; 01-14-2024 at 01:03 PM.

  8. #8
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: How can I extract unique months from one column to an another column?

    Try it now. If incorrect, provide expected answers, please.
    Attached Files Attached Files

  9. #9
    Forum Contributor
    Join Date
    11-26-2014
    Location
    Bosnia&Herzegovina
    MS-Off Ver
    Office2013
    Posts
    281

    Re: How can I extract unique months from one column to an another column?

    Yes, Thanks a lot, but what about when i have two guys with same name but different company different licence plate of lorry? B&C columns
    P.s. Can this table array be on different shhet inside workbook??

  10. #10
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: How can I extract unique months from one column to an another column?

    No more guesses from me. SHOW ME expected answers in a file.

  11. #11
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: How can I extract unique months from one column to an another column?

    Names sorted.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Use [Ctrl]+[Shift]+[Enter] .
    Attached Files Attached Files

+ 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. Replies: 4
    Last Post: 12-10-2022, 06:23 PM
  2. Replies: 3
    Last Post: 03-14-2021, 10:26 PM
  3. Replies: 3
    Last Post: 03-26-2020, 12:31 PM
  4. Extract unique list from column
    By lamdl in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-25-2014, 05:17 AM
  5. Extract unique value from Column
    By Mambaout626 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-13-2014, 03:08 AM
  6. Replies: 0
    Last Post: 04-17-2011, 02:29 AM
  7. Extract Unique entries in a column
    By Jeff in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-18-2005, 04:05 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