Forum Discussion
FILTER Function
Im trying to execute a SMALL with a nested ROW function which is not working and someone suggested I use the FILTER function. I went to try and found that I dont have this function and I believe tha...
YES! It worked!! WHY did it work?? for my edification 🙂
disler85 Your formula worked I'm my Excel as I supports dynamic arrays. If yours doesn't you need to avoid references like ROW(A2:A9) and make the array absolute (i.e. with $-signs). Then you can copy the formula down until you get the !NUM# error.