Sorting
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!
|