I am trying to perform a TTEST on conditional values that are non-contiguous. I am working off of a master sheet that has all my data and need to sort it conditionally (>0 & < 15, >15 & <45, >45 & <90, etc.). I have not found a way to do this using built-in excel functions.
Additionally, I have tried to create a macro that will copy the master sheet to a new worksheet then filter it to the desired conditions, but when I perform the TTEST, it uses ALL the data entries, not just the desired filters entries and therefore returns a useless TTEST.
Ideally I would like to just be able to input the data into my master sheet and then have all other sheets conditionally updated automatically.
Any help would be greatly appreciated.
Bookmarks