Hello,
I have several numbers in column A, and I use the AVERAGEIFS function in cell B1 to calculate the average of numbers that are greater than or equal to 70 and less than or equal to 100, which is very easy and works very well. Now, what if I wanted a list generated of all the numbers that met my criteria, say in column C. Is there a way to do that without VBA?
This would of course easily apply to other -IFS functions such as MAXIFS and MINIFS.
Also I make my own "STDEVIFS" function, by using as many required nested IF functions, in the form of an array formula. It would be nice to be able to get the list of these values too.
Thanks much for any input!
I have several numbers in column A, and I use the AVERAGEIFS function in cell B1 to calculate the average of numbers that are greater than or equal to 70 and less than or equal to 100, which is very easy and works very well. Now, what if I wanted a list generated of all the numbers that met my criteria, say in column C. Is there a way to do that without VBA?
This would of course easily apply to other -IFS functions such as MAXIFS and MINIFS.
Also I make my own "STDEVIFS" function, by using as many required nested IF functions, in the form of an array formula. It would be nice to be able to get the list of these values too.
Thanks much for any input!