+ Reply to Thread
Results 1 to 51 of 51

unique-distinct-dependent-lists1-three-columns

Hybrid View

  1. 02-05-2021, 05:12 AM #1
    Grace Tan
    Grace Tan is offline
    Registered User
    Join Date
    01-29-2021
    Location
    Singapore
    MS-Off Ver
    365
    Posts
    25

    Re: unique-distinct-dependent-lists1-three-columns

    Hi Murthy

    1) Yes this is working - E1=1010 and F1=Hard Disc ( then "*" is third column ) then Drop down is from sheet 3

    But my production data has the following data as highlight in attach in YELLOW: which I need to lookup to sheet 3 when F1 ="*"

    Thank & Regard
    Grace
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-05-2021, 05:32 AM #2
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: unique-distinct-dependent-lists1-three-columns

    Quote Originally Posted by Grace Tan View Post
    Hi Murthy
    1) Yes this is working - E1=1010 and F1=Hard Disc ( then "*" is third column ) then Drop down is from sheet 3
    Pl post excel workbook not images and word files.
    Pl see file.For * in second column, then drop down is from Sheet3, it is working.
    Last edited by kvsrinivasamurthy; 02-05-2021 at 05:36 AM.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.
    Reply With QuoteRegister To Reply
  3. 02-05-2021, 10:47 AM #3
    Grace Tan
    Grace Tan is offline
    Registered User
    Join Date
    01-29-2021
    Location
    Singapore
    MS-Off Ver
    365
    Posts
    25

    Re: unique-distinct-dependent-lists1-three-columns

    Hi Murthy

    Attach is the excel file.

    Thank & Regard
    Grace
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Dependent lists based on multiple not unique table columns
    By jaryszek in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-18-2020, 09:59 AM
  2. [SOLVED] Distinct Dependent Drop Down Lists
    By pbundrant in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-06-2018, 03:20 PM
  3. [SOLVED] Compare 2 columns extract unique / distinct records in 3 column without vba
    By sanjuss2 in forum Excel General
    Replies: 2
    Last Post: 12-04-2014, 04:59 AM
  4. Create a Distinct Unique list for 2 Columns
    By boldcode in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-06-2014, 05:10 PM
  5. VBA Dependent Unique Distinct Lists
    By hobbiton73 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-10-2013, 02:42 PM
  6. Multiple Unique Distinct Values from Multiple Columns of Data
    By mym1nd in forum Excel General
    Replies: 1
    Last Post: 03-02-2011, 04:14 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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1