+ Reply to Thread
Results 1 to 2 of 2

Put date in column on sheet1 into a separate column in sheet2 based on number of occurance

  1. #1
    Registered User
    Join Date
    01-27-2020
    Location
    Tempe, Arizona
    MS-Off Ver
    2013
    Posts
    1

    Put date in column on sheet1 into a separate column in sheet2 based on number of occurance

    This is a spreadsheet for tracking pairings in a couples golf league. The Pairings sheet has the date in column A, and the pairings in however many columns that there are teams. On the Calcs sheet, column A has all of the possible pairings, and column B has the count of how many times each couple has been paired together. I would like to have column C out (Calcs sheet), bring in the all of the dates that each couple has been paired together. So if A and B played together on Dec 22nd and Jan 26th, on the Calcs sheet, I would like C1 to be Dec 22 and D1 to be Jan 26. I have looked at VLOOKUP and INDEX/MATCH until I have a headache. Thank you in advance for any help.
    Attached Files Attached Files

  2. #2
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: Put date in column on sheet1 into a separate column in sheet2 based on number of occur

    In C1 put this array formula:
    (This is an array formula so make sure to use CTRL+SHIFT+ENTER when entering this formula. If done so correctly { } will be added around your formula.

    =IFERROR(INDEX(Pairings!$A$1:$A$6,SMALL(IF($A1=Pairings!$B$1:$D$6,ROW(Pairings!$B$1:$D$6),""),COLUMN(A:A))),"")


    then drag across and down
    <----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.

+ 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. Delete rows based on matching dates in Sheet1 Column A with date in Sheet2 Cell K1
    By robertaw in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-24-2015, 02:30 PM
  2. [SOLVED] Need to copy a row from Sheet1 to Sheet2 then auto delete from Sheet 1 based on Column G
    By jingles9 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-20-2015, 08:11 AM
  3. Replies: 2
    Last Post: 07-14-2015, 04:32 PM
  4. Find all instances from Sheet1 Column B in Sheet2 Column B, Update Sheet2 Column A
    By djsmith97 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2015, 08:57 AM
  5. move data from sheet1 to sheet2 based on date in column1 of sheet1
    By pcaldwell in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-10-2014, 03:20 PM
  6. [SOLVED] copy data from sheet1 to sheet2 based on column (A) sheet1 and column (C) sheet2
    By AWITCHER in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-13-2014, 03:20 PM
  7. [SOLVED] Take Data From Column on Sheet1 and Insert Into Next Blank Row on Sheet2 Then Clear Sheet1
    By abutler911 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2013, 06:30 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