Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"