Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search of particular combinations
In Column A & B there is different name but I want "yes" for below
particular combination else "No" A A Yes A B Yes A C Yes A D Yes B A Yes B B Yes B C Yes B D Yes C A Yes C B Yes C C Yes C D Yes D A Yes D B Yes D C Yes D D Yes A E No D F No C L No |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search of particular combinations
Hi,
Build your self a table of 'Yes' combinations somewhere out of the way, I used column J and it looks like this and note aa is in a single cell. aa ab ac ad ba bb bc bd ca cb cc cd da db dc dd then this formula in c1 and drag down =IF(ISNA(VLOOKUP(A1&B1,$J$1:$J$16,1,FALSE)),"No"," Yes") Mike "kashish" wrote: In Column A & B there is different name but I want "yes" for below particular combination else "No" A A Yes A B Yes A C Yes A D Yes B A Yes B B Yes B C Yes B D Yes C A Yes C B Yes C C Yes C D Yes D A Yes D B Yes D C Yes D D Yes A E No D F No C L No |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combinations | Excel Worksheet Functions | |||
combinations | Excel Discussion (Misc queries) | |||
Sum of combinations | Excel Discussion (Misc queries) | |||
getting combinations | New Users to Excel | |||
Combinations | Excel Worksheet Functions |