Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if val in col3 is one of 13 codes (list), apply factor to val in c
Need a function to apply a factor to certain values (col2) in a large table
if val in same row, col3 is one of 13 codes - a list in col6. For illustration (caps letters denote excel column labels): A B C D E F G H I J K L M 23 a b 14 c g 42 d e 31 b 64 f 23 g 99 g so for this example, the function would be inserted in a new column, say L. It looks for instances of b,e and g in col B and if found returns the corresponding value in Col A* a factor. Suggestions appreciated. Or(Exact) doesn't work. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if val in col3 is one of 13 codes (list), apply factor to val in c
Hi,
If your codes are listed in Column 6 (Say, F1:F13), then in C2 enter: =IF(COUNTIF(F1:F13,C2)0,"factor","no factor") Is this what you need? Regards - Dave. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Apply a percentage factor to a base number | Excel Worksheet Functions | |||
Apply a percentage factor to a base number | Excel Worksheet Functions | |||
List Project Codes | Excel Worksheet Functions | |||
Any function to determine the smallest common factor from a list? | Excel Discussion (Misc queries) | |||
How do I apply a list of zip codes to a map in Excel? | Excel Discussion (Misc queries) |