sorting data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I sort data when the details colum has different description
eg. details column has
cable & wireless: Invoice # and
cable & wireless
I want all cable & wireless information
 
You don't want to sort, you want to filter.

Data>Filter>Autofilter>Custom>Contains "cable and wireless"

Or maybe just "cable"?


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top