| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting data from a column with multiple conditions
Hi
I am looking for a VBA Code to select ascii data instead of numeric with multiple conditions a= = Evaluate("SUMPRODUCT(--(data!$A$2:$A$65536=B3),--(data!$b$2:$b $65536=B4),--(data!$D$2:$D$65536=B12),(data!$k$2:$k$65536))") This works fine if the data in the K column is numbers; but if it is characters then a = zero anyone got an idea? Thanks in advance Kurt |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data return using multiple conditions | Excel Worksheet Functions | |||
| Count and Sum Multiple Conditions in one column | Excel Discussion (Misc queries) | |||
| Macro to concatenate multiple rows in a column, without selecting each group manually | Excel Programming | |||
| Multiple conditions data analysis | Excel Worksheet Functions | |||
| Selecting data for certain conditions. | Excel Programming | |||
Linear Mode
