View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RaqAc RaqAc is offline
external usenet poster
 
Posts: 1
Default Sorting multiple columns that have similar data

I am trying to sort a worksheet where multiple colums contain the same type
of data; the data duplicates down a column but not across a row. I can't
figure out how to sort/filter for any rows that have that duplicate data in
any column. Instead I wind up sorting the first column I need, which only
allows you to sort the remaining rows.