FILTER Function

[disler85]

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! 

[#2]

@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.

[#3]

@Riny_van_Eekelen 

YES! It worked!! WHY did it work?? for my edification :)

[#4]

@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.