+ Reply to Thread
Results 1 to 2 of 2

conditional selection

  1. #1
    Registered User
    Join Date
    hyderabad, india
    MS-Off Ver
    Excel 2003

    conditional selection

    dear members,

    i am attaching work sheet with example.

    under each name, there are many condition and on selecting any one name, the respective conditions only should be displayed.

    pls guide me.

    Attached Files Attached Files

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010

    Re: conditional selection

    Create a helper column, say column-D:

    D2: =IF(A2=$E$3,ROW(),"")

    E5; =INDEX($B$2:$B$19,MATCH(SMALL($D$2:$D$19,ROW(A1)),$D$2:$D$19,0))
    F5: =INDEX($C$2:$C$19,MATCH(SMALL($D$2:$D$19,ROW(A1)),$D$2:$D$19,0))

    Copy all formulas down the column.

    Apply Conditional Formatting to cells in columns-E & F, setting the font color to the same color as the cell background. This will hide the #NUM errors returned by the formulas when the number of matching entries is fewer than the number of cells with the formula
    Attached Files Attached Files

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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