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 that I have the most up to date excel (see attached photos for my Excel version and the message I posted on an Excel forum, respectively).
If I can get the correct info with the way i'm doing it or using one function, that would be awesome, and I would appreciate any and all help! THANKS!
3 Replies
disler85 Can't really test it as I'm on MS365, but try this in G:
=SMALL($F$2:$F$9,ROW(A2)-1)
........and copy down.
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.
