Thread: VSORT
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
scott scott is offline
external usenet poster
 
Posts: 577
Default 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