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.
Murari
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
Palmetto
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks