Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello,
I have data from two groups interleaved in the same column. For the sake of simplicity, let's imagine group A: rows 1-3,7-9; group B: rows 4-6,10-12. I want to compare groups A and B with a ttest -witout having to displace values everywhere-. However, I can not specify ranges, otherwise the ttest gets too many arguments (the coma for specifying ranges is taken as the coma that separates the different arguments. I tried using named selections (shift+click on cells of group A, then name 'groupA' at the left of the function bar, similar for group B), but it still doesn't work. I still get ERROR IN VALUE. Am I missing a simple workaround for that ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Join non-contiguous ranges into one range via named range? | Excel Discussion (Misc queries) | |||
multiple range array with ttest | Excel Worksheet Functions | |||
non-contiguous cells as arguments to XIRR | Excel Discussion (Misc queries) | |||
pasting non-contiguous range of cells to new row, same cell locati | New Users to Excel | |||
TTest with values in non-contiguous ranges | Excel Worksheet Functions |