Results 1 to 10 of 24

Thread: Get List Of All Values Corresponding To A Value In The Adjacent Column

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 07-27-2014, 04:22 PM #21
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi


    In E1

    =INDEX(B1:B7,SMALL(IF(A1:A7=C1,ROW(B1:B7)-ROW(E1)+1),D1))

    It's an array formula. Where C1 is the dropdown value and E1 is the instance.

    Please find attached.
    Attached Files Attached Files
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Fill Combobox Based On Values In Adjacent Column
    By rydysh in forum Excel Help
    Replies: 5
    Last Post: 10-03-2013, 07:27 AM
  2. Find Maximum Value Corresponding To Adjacent Column
    By shonu in forum Excel Help
    Replies: 6
    Last Post: 05-22-2013, 02:23 AM
  3. Lookup All Corresponding Values Match Criteria In Adjacent Column Array Formula
    By d380013 in forum Excel Help
    Replies: 16
    Last Post: 04-19-2013, 08:20 PM
  4. Copy Row To A New Sheet If A Value Found In Adjacent Column
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 4
    Last Post: 08-17-2012, 05:42 PM
  5. Automatic Subtraction Of Column Values To Adjacent Column
    By sanjeevi888 in forum Excel Help
    Replies: 3
    Last Post: 08-05-2012, 09:16 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
  •  

Forum Rules