Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a list of option with bolleans associated with them in range A1:B3:
Option 1 TRUE Option 2 TRUE Option 3 FALSE Then I have data list which uses these Options as validation items in range C1:C7: Option 1 Option 1 Option 1 Option 2 Option 2 Option 2 Option 3 I want to pull the range in C1:C7 into a SUMPRODUCT formula in the form {TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,FALSE,} and then coverted to booleans {1,1,1,1,1,1,0,}. I know that if C1:C7 were excpressed as TRUE/FALSE I would do thei following below. SUMPRODUCT(--(C1:C7=TRUE)) How do I do the same considering the the values in C1:C7 are not expressed as TRUE/FALSE. I need to include a lookup extract the booleans. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can SUMPRODUCT be used to extract varying data in a column? | Excel Worksheet Functions | |||
Extract last and next-to-last entries in a range | Excel Worksheet Functions | |||
Advanced Filtering Extract Range Missing,etc | Excel Worksheet Functions | |||
Boolean comparison: range vs. single cell | Excel Worksheet Functions | |||
Extract values from formulas | Excel Discussion (Misc queries) |