When doing a Sort (numerical Sort) on data that is populated in a Col is there a way for Excel to skip a line when data is missing? i.e. If Sorting items 1-10 and item 4 is missing, leave line 4 blank but continue the rest of the Sort.
When doing a Sort (numerical Sort) on data that is populated in a Col is there a way for Excel to skip a line when data is missing? i.e. If Sorting items 1-10 and item 4 is missing, leave line 4 blank but continue the rest of the Sort.
Last edited by DonG; 10-15-2011 at 02:27 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks