Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi!
Hope you can help me make if function that can compute for 13 conditions. The data I'm working on is as follows: A B C D E F G H I J K L M 1 1 2 1 3 1 4 1 5 1 6 1 I need a summary which says: If Column A = 1, XS If Column B = 1, S If Column C = 1, M If Column D = 1, L If Column E = 1, XL and so on... A website I checked suggest VBA functions, but I really don't know how to work with them. Hope you can help me out. Super thanks! :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I know which cell a function is called from? | Excel Worksheet Functions | |||
If Function with Multiple Conditions | Excel Discussion (Misc queries) | |||
Function to summarize based on 2 conditions? | Excel Discussion (Misc queries) | |||
Custom function | Excel Worksheet Functions | |||
SUMIF function with 2 conditions | Excel Worksheet Functions |