Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I have two columns A and B as shown below. When I choose North in Col A, I should get only values correspondig to North in Col B . ( 1,4,2 and 6). Can you help me with the right formula? Col A Col B North 1 South 4 East 2 West 3 South 6 South 5 North 4 North 2 West 1 East 2 North 6 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic Drop Down List | Excel Discussion (Misc queries) | |||
Dynamic Date Drop-down List | Excel Worksheet Functions | |||
How to feed dynamic information to a drop down List (Validation Feature)? | Excel Worksheet Functions | |||
Dynamic Drop Down List | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |