Sorting Many Columns And Keep Information In Rows Intact

If you want to sort many columns ( more than 3 columns ) it`s easy.

# Use CONCATENATE worksheet function to merge numbers you want to sort

# Write CONCATENATE beside each cell you want to sort later

# Then Go to Sort icon in tools bar

# Sort Ascending or Descending as you want

# Remove any merged cells to work well.

# Thanks....

Publish Post

No comments: