Results 1 to 6 of 6

index match multiple unique values based on one criteria

Threaded View

  1. #1
    Registered User
    Join Date
    01-15-2013
    Location
    Indianapolis
    MS-Off Ver
    Office 365
    Posts
    78

    index match multiple unique values based on one criteria

    This one has me confused because I cant put these in a list, they have to go to the right up to 3 columns.

    In column A I have a list of customers
    In column B I have a list of appointments

    In column E I have a list of Unique Appointment numbers
    In column F,G, and H I basically want to transpose the unique customers next to their respective Appointment numbers

    I can do this easily if i make a list but trying to work from left to right in multiple columns has me perplexed.

    I need a formula to copy down in columns F,G, and H

    I have provided examples in the upload of what the data should look like.

    Many thanks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 08-21-2018, 05:45 PM
  2. [SOLVED] Index & Match Formula for Unique Values On Multiple Criteria
    By JenMasters84 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-10-2018, 03:01 PM
  3. [SOLVED] Looking for help on unique value pull with multiple criteria using Index Match
    By shinobi2u in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-09-2017, 05:07 PM
  4. [SOLVED] Index & Match Formula for Unique Values On Multiple Criteria
    By Neilesh Kumar in forum Excel General
    Replies: 2
    Last Post: 03-24-2017, 10:13 AM
  5. [SOLVED] Index & Match Formula with Unique Values bases on a criteria
    By Neilesh Kumar in forum Excel General
    Replies: 5
    Last Post: 03-24-2017, 06:22 AM
  6. Listing Unique values based on partial match criteria
    By mamachrissy1028 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-17-2016, 05:23 PM
  7. [SOLVED] Listing Unique values based on partial match criteria
    By mamachrissy1028 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-11-2016, 11:38 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