Many thanks Vabz.
I've got it working. The problem was that I had formula in the 'blank'
cells.
I've now restricted the list to cells containing values which works.
Thanks again.
On Wednesday, 24 December 2014 11:45:04 UTC, Eddie wrote:
> Hi,
> I'd like to use the following array formula to s
check this excel file..
+
*I did not do this for you. God is here working through me for you.*
On Wed, Dec 24, 2014 at 5:44 PM, Vaibhav Joshi wrote:
> Your original formula will also work but you need to start from cell B8 &
> downward...
>
> Check again...
>
> Cheers!!
>
> +
> *I did n
Your original formula will also work but you need to start from cell B8 &
downward...
Check again...
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Dec 24, 2014 at 5:35 PM, Eddie wrote:
> The original array formula doesn't work for me with numbers.
The original array formula doesn't work for me with numbers. it only lists
the lowest value in the returned list. :(
On Wednesday, 24 December 2014 11:45:04 UTC, Eddie wrote:
>
> Hi,
> I'd like to use the following array formula to sort numerical values
> rather than text. Is anybody able to con
