+ Reply to Thread
Results 1 to 3 of 3

Find and list all instances of a value and associated column

  1. #1
    Registered User
    Join Date
    05-26-2022
    Location
    USA
    MS-Off Ver
    365
    Posts
    27

    Find and list all instances of a value and associated column

    I'm attempting to complete a time off request book.

    The user will enter name, type of request, and date(s) in the VBA form. The form will then list the requests in order separating single date requests from multiple. (Requests Sheet)

    My problem comes in when I need to list all the requests by date (DATA Sheet). I've listed a sample of what i would like to see below each date but I cant figure it out. I've tried some index and array formulas but the closest I can get is listing of the first column in the whole array. I would like for a formula to look at all the information in (Requests Sheet K5:AT30) and return all requests that were made on the same day in the data sheet.

    For example

    6/1 6/2 Etc....
    Req1 Req1
    Req2
    Req3

    The data will then help populate the Calendar for viewing. (June 22)

    I'm open to any ideas including a VBA option, or redoing the way I have the requests listed.

    Any help would be appreciated.

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,945

    Re: Find and list all instances of a value and associated column

    Try something like this file.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    05-26-2022
    Location
    USA
    MS-Off Ver
    365
    Posts
    27

    Re: Find and list all instances of a value and associated column

    Thank you so much! This works great!

+ 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: 1
    Last Post: 01-31-2020, 11:27 PM
  2. New User - How to find all instances within a column?
    By Grusvag in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-17-2016, 04:35 PM
  3. [SOLVED] find all instances for specific value in first column
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-10-2016, 07:57 PM
  4. [SOLVED] Find the first and last instances of a text value in a column
    By Tamarissa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-15-2015, 12:13 PM
  5. Locate all the instances of a list of values in one column in another column
    By norwoodkd2001 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-01-2015, 09:52 AM
  6. how to find Devin cell Vale the absence of first value
    By Liju144 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-01-2013, 01:28 PM
  7. how to find second cell Vale the absence of first value
    By Liju144 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-30-2013, 02:48 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