VSORT
 

I have a ss. On one page I have the VSORT function. It is working great. I
sort a column in ascending order. I have six cells with this function in and
if the top cell is 250 and the cells below it are lower vsort fills in those
six cells in ascending order some of these cells are also blank. I am trying
to duplicate this on another sheet in my ss and am not succedding. Yes I am
pushing ctrl shift enter when entering in the vsort. Any help would be
greatly appreciated.
Eample
Column a
250
blank
225
blank
156
vsort in cell b3 answer 250
vsort in cell b4 answer 225
vsort in cell b5 answer 156
when I duplicate this on a different sheet
vsort in cell b3 answer 250
vsort in cell b4 answer 250
vsort in cell b6 answer 250
What am I doing diferent

Thanks again Scott
235
blank
156
Vsort in cell

VSORT
 

I think you'll find that VSORT is not a native Excel function. If you are
using an Add-In, you probably need to ask the author of the Add-In.
--
David Biddulph

scott wrote:
I have a ss. On one page I have the VSORT function. It is working
great. I sort a column in ascending order. I have six cells with this
function in and if the top cell is 250 and the cells below it are
lower vsort fills in those six cells in ascending order some of these
cells are also blank. I am trying to duplicate this on another sheet
in my ss and am not succedding. Yes I am pushing ctrl shift enter
when entering in the vsort. Any help would be greatly appreciated.
Eample
Column a
250
blank
225
blank
156
vsort in cell b3 answer 250
vsort in cell b4 answer 225
vsort in cell b5 answer 156
when I duplicate this on a different sheet
vsort in cell b3 answer 250
vsort in cell b4 answer 250
vsort in cell b6 answer 250
What am I doing diferent

Thanks again Scott
235
blank
156
Vsort in cell

VSORT
 

It's part of the Morefunc addin

http://xcell05.free.fr/morefunc/english/

Mike


"scott" wrote:

I have a ss. On one page I have the VSORT function. It is working great. I
sort a column in ascending order. I have six cells with this function in and
if the top cell is 250 and the cells below it are lower vsort fills in those
six cells in ascending order some of these cells are also blank. I am trying
to duplicate this on another sheet in my ss and am not succedding. Yes I am
pushing ctrl shift enter when entering in the vsort. Any help would be
greatly appreciated.
Eample
Column a
250
blank
225
blank
156
vsort in cell b3 answer 250
vsort in cell b4 answer 225
vsort in cell b5 answer 156
when I duplicate this on a different sheet
vsort in cell b3 answer 250
vsort in cell b4 answer 250
vsort in cell b6 answer 250
What am I doing diferent

Thanks again Scott
235
blank
156
Vsort in cell

VSORT
 

Thnaks guys. I know it is part of the More Function. I have taht add in in
the ss I am working on. I original put that into my ss. I just don't get why
it will not work on another sheet. thanks

"Mike H" wrote:

It's part of the Morefunc addin

http://xcell05.free.fr/morefunc/english/

Mike


"scott" wrote:

I have a ss. On one page I have the VSORT function. It is working great. I
sort a column in ascending order. I have six cells with this function in and
if the top cell is 250 and the cells below it are lower vsort fills in those
six cells in ascending order some of these cells are also blank. I am trying
to duplicate this on another sheet in my ss and am not succedding. Yes I am
pushing ctrl shift enter when entering in the vsort. Any help would be
greatly appreciated.
Eample
Column a
250
blank
225
blank
156
vsort in cell b3 answer 250
vsort in cell b4 answer 225
vsort in cell b5 answer 156
when I duplicate this on a different sheet
vsort in cell b3 answer 250
vsort in cell b4 answer 250
vsort in cell b6 answer 250
What am I doing diferent

Thanks again Scott
235
blank
156
Vsort in cell