LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default specify non-contiguous cell range as arguments to TTEST()

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Join non-contiguous ranges into one range via named range? ker_01 Excel Discussion (Misc queries) 3 May 1st 09 11:09 AM
multiple range array with ttest erinlm Excel Worksheet Functions 2 April 21st 08 05:16 PM
non-contiguous cells as arguments to XIRR Jim Skrydlak Excel Discussion (Misc queries) 0 January 7th 08 11:02 PM
pasting non-contiguous range of cells to new row, same cell locati Not excelling at macros New Users to Excel 3 April 4th 06 08:57 PM
TTest with values in non-contiguous ranges Kristina Excel Worksheet Functions 6 August 2nd 05 12:02 AM


All times are GMT +1. The time now is 04:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"