Hi Guys,
Its problem time again. I want a function or a method that can will choose the first from a list. The list doens't start from a specific point, but is flexible, so I need the formula to incorporate this.
e.g. if I have:
95300
26500
3000
6000
510000
I want it to choose the first, but there may be no values in cells above this number
Any suggestions.
Cheers
IMRAN
Its problem time again. I want a function or a method that can will choose the first from a list. The list doens't start from a specific point, but is flexible, so I need the formula to incorporate this.
e.g. if I have:
95300
26500
3000
6000
510000
I want it to choose the first, but there may be no values in cells above this number
Any suggestions.
Cheers
IMRAN