Hi All,
I am looking for a function that can look down a list of values and return all the values greater than a certain number. I would like to vary the number I am comparing with using a drop down menu, so I am not looking to use the advanced filter, but an actual formula.
Can anyone assist.
Thanks
Herbert
I am looking for a function that can look down a list of values and return all the values greater than a certain number. I would like to vary the number I am comparing with using a drop down menu, so I am not looking to use the advanced filter, but an actual formula.
Can anyone assist.
Thanks
Herbert