Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |