remote functions
I have a large set of data that I perform many different types of analysis
on. I use sequence of IF functions in array formulas to look at specific subsets of the data; eg. a typical formula {=median(if(a2:a4400=1,if(c2:c4400="er",k2:k4400)) )} I perform analysis on different subsets of the data, which mean that I have to go back and change the IF functions for each and every calculation, which is a pain because I have well over 100 different calculations. Is there any way that I could set things up so that the IF function arguments are defined in a separate section of my database, so that when I changed those cells, all the IF functions in the calculations would change automatically, eg. in my example, if instead of looking at IF(a2:a4400=1) I wanted to look at IF(ef2:ef4400="surv")?? Thanks |
|
All times are GMT +1. The time now is 06:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com