Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use intersection of column and TWO ranges in formula?
Thanks to those who helped before, I can use the intersection of a column
and a named range in a formula, as in =STDEV((col7 rng1Work)). Now, what happens when I want to calculate across TWO ranges? As in =STDEV of the values in the intersection of the range "col7" and all the values in both "rng1Work" and "rng2Work"? If "col7" was column "D", rng1Work included rows 4-7, and rng2Work included rows 14-17, this would be the equivalent of =STDEV(D4:D7, D14:D17). Ed |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use intersection of column and TWO ranges in formula?
=STDEV(col7 rng1Work,col7 rng2Work)
-- Regards, Tom Ogilvy "Ed" wrote in message ... Thanks to those who helped before, I can use the intersection of a column and a named range in a formula, as in =STDEV((col7 rng1Work)). Now, what happens when I want to calculate across TWO ranges? As in =STDEV of the values in the intersection of the range "col7" and all the values in both "rng1Work" and "rng2Work"? If "col7" was column "D", rng1Work included rows 4-7, and rng2Work included rows 14-17, this would be the equivalent of =STDEV(D4:D7, D14:D17). Ed |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use intersection of column and TWO ranges in formula?
Perfect! Thanks, Tom.
Ed "Tom Ogilvy" wrote in message ... =STDEV(col7 rng1Work,col7 rng2Work) -- Regards, Tom Ogilvy "Ed" wrote in message ... Thanks to those who helped before, I can use the intersection of a column and a named range in a formula, as in =STDEV((col7 rng1Work)). Now, what happens when I want to calculate across TWO ranges? As in =STDEV of the values in the intersection of the range "col7" and all the values in both "rng1Work" and "rng2Work"? If "col7" was column "D", rng1Work included rows 4-7, and rng2Work included rows 14-17, this would be the equivalent of =STDEV(D4:D7, D14:D17). Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
intersection of a row with a column | Excel Discussion (Misc queries) | |||
How To Format Row Column Intersection | Excel Discussion (Misc queries) | |||
LOOKUP FORMULA INTERSECTION OF A COLUMN AND (TWO) VALUES IN A ROW | Excel Worksheet Functions | |||
I NEED A FUNCTION TO FIND IF THERE IS AN INTERSECTION BETWEEN 2 DATE RANGES | Excel Worksheet Functions | |||
intersection of row and column | Excel Worksheet Functions |