4 Replies Latest reply on Mar 16, 2012 7:27 AM by Andy Cotgreave

    Find lowest values in the window/view

      I apologize for this seemingly simple question, but I don't feel like I have time to continue my search for an answer. (I've spent a couple hours already)

      I need a formula that will allow me to find the lowest 3 values within the window. I am filtering out the top 25 values out of 1000 (give or take) and instead of find the lowest values out of the 1000 I want to find the lowest values out of the top 25. This seems like a simple calculation but I just can't seem to wrap my head around it.