Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have one column with data but some rows are blank. Is is possible to set up
function like "advanced sort" where the data from the column that isnt blank is copied to another column then sorted, but so that if any items are altered in the first column the second column automatically updates itself without the need to run a sort again? Hope that makes sense! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Sorting Sorting Sorting | Excel Discussion (Misc queries) | |||
Sorting | New Users to Excel | |||
Advice sought: Multiple column sorting | Excel Worksheet Functions | |||
sorting number in ascending order | Excel Discussion (Misc queries) |