+ Reply to Thread
Results 1 to 3 of 3

Need to pull multiple numbers from column b with same prefix in column a - separately

  1. #1
    Registered User
    Join Date
    05-15-2012
    Location
    CA
    MS-Off Ver
    Excel 2003 -mostly
    Posts
    3

    Need to pull multiple numbers from column b with same prefix in column a - separately

    Hello,
    I'm trying to pull multiple store numbers from sheet 1 to sheet 2. These store numbers all have a trailer number associated with them, IE. A1 = trailer #, B1 = store number.
    I need a formula (could be a macro if multiple are needed) to pull all stores, in separate cells, with the same trailer number to a column in sheet 2

  2. #2
    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,206

    Re: Need to pull multiple numbers from column b with same prefix in column a - separately

    Please post a sample file showing expected results

  3. #3
    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,206

    Re: Need to pull multiple numbers from column b with same prefix in column a - separately

    To post a file:

    Click "Go Advanced" and either "Paper Clip" icon or "Manage attachments".

    Click "Add Files"

    Click "Browse"

    Select your file

    Click "Upload"

    Click "Done"

+ 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. [SOLVED] How to replace dash in a column of numbers with a space and add a prefix
    By HH61 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-04-2014, 02:33 PM
  2. [SOLVED] Removing duplicates from multiple columns (treating each column separately)
    By Rob8489 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-24-2013, 05:56 PM
  3. [SOLVED] I need to filter numbers separately that ends with a specific digit in the whole column?
    By motivationalist in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-12-2013, 11:35 AM
  4. adding prefix numbers to text in column automatically?
    By cfjess012 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-22-2008, 11:28 PM
  5. Replies: 8
    Last Post: 05-09-2008, 09:59 AM
  6. Replies: 2
    Last Post: 07-31-2006, 11:48 AM
  7. Adding a prefix to all numbers in a column.
    By Randy in forum Excel General
    Replies: 2
    Last Post: 02-05-2006, 05:00 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1