| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Defining a range as a subset of cells in another range
If I have the following range:
Row/Col A B 1 2 10 2 2 2 3 3 8 4 4 5 5 3 10 6 2 3 7 2 5 8 1 5 9 2 6 10 3 9 Suppose I have a function that is called by MyFunction(B1:B12). Is there any way within the MyFunction routine to define a range of the numbers in column B for which column A = 2. If I were doing a SumProduct, the idea would by SumProduct(--(A1:A10=2),B1:B10). In this case, however, I just want a range that is the equivilent of (--(A1:A10=2),B1:B10). The new range would be include cells B1, B2, B6, B7 and B9. I was hoping to be able to do this without any kind of For/Next loop. Thanks for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Defining a Range with Cells(r,c) | Excel Programming | |||
| Trying to set a pivot field to a subset of values listed in range of cells | Excel Programming | |||
| Trying to set a pivot field to a subset of values listed in range of cells | Excel Programming | |||
| Defining a range by the contents of cells? | Excel Programming | |||
| Defining Range using Cells | Excel Programming | |||
Threaded Mode
