+ Reply to Thread
Results 1 to 2 of 2

Find all instances (multiple) of a list of values and return the column and row number

  1. #1
    Registered User
    Join Date
    01-31-2020
    Location
    Orlando, FL
    MS-Off Ver
    2018 MS for Mac
    Posts
    1

    Find all instances (multiple) of a list of values and return the column and row number

    I currently have a list of values that are randomly populating a table with numbered rows and column headings. I would then like to be able to search this randomly populated table and pull a list of all the column/row identifiers separated by commas where the value can be found for each value within the original list. I would also like to be able to have the option of making the original list longer by leaving blank cells at the bottom that can be filled in to be randomly populated and then have their column/row identifiers pulled, however if the cells are blank in the original list then to just ignore them.

    Attached are a screenshot of the spreadsheet and the original spreadsheet. Thank you!
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: Find all instances (multiple) of a list of values and return the column and row number

    Named ranges:
    Codes =Sheet1!$B$2:INDEX(Sheet1!$B:$B,COUNTA(Sheet1!$B:$B)+1)
    square0 =Sheet1!$D$2:$J$8
    square1 =Sheet1!$L$2:$R$8
    square2 =Sheet1!$T$2:$Z$8
    square3 =Sheet1!$D$10:$J$16
    square4 =Sheet1!$L$10:$R$16
    square5 =Sheet1!$T$10:$Z$16


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by protonLeah; 02-01-2020 at 01:28 AM. Reason: added Application.Volatile
    Ben Van Johnson

+ 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. VBA find multiple instances of value in range, return value in col for each row
    By Stigmata in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-04-2019, 04:49 PM
  2. Return values for multiple instances
    By diva666 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-12-2016, 09:08 AM
  3. [SOLVED] Find value in list and return multiple values
    By Gatis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2015, 01:51 AM
  4. Replies: 4
    Last Post: 10-27-2014, 04:07 PM
  5. [SOLVED] Complex VLOOKUP, multiple instances vertical, return subsequent instances horizontally
    By Miles_2804 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-12-2013, 11:54 AM
  6. Replies: 1
    Last Post: 02-12-2013, 06:02 PM
  7. Find unique value in column and return multiple values
    By DWolf75 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2011, 08:32 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