Thread: VSORT
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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