How to filter single column in a jtable?

Filter by information in multiple columns

• My team is building a categorical spreadsheet that includes business information and what categories that business matches for our marketing needs (i.e. nightlife, music, theater, dining, etc.). Our sheet will be set up something like this: Column A - Business Name (Opera House) Column B - Main Category (Theater) Column C - Sub Cat1 (Music) Column D - Sub Cat2 (Nightlife) Column E - Sub Cat3 (Attractions) In order to make the data easier to use, I'm looking for a way to show the business name that matches a specific category type. So if I wanted to know all the business that are music related, I would need to be able to search/filter columns B-E simultaneously and if they contain "music" will return that business name. I hope that makes sense!

• Answer:

  First of all sorry for the delayed reply, since there was some problem in my internet connection. I am not clear whether this is what you are looking for. Anyway have a look in the below links. http://www.excelfunctions.net/ExcelFilter.htmlhttp://www.microsoft.com/business/smb/en-ca/smallbiz/products/howto/use-excel-filtering-to-find-data-fast.mspxhttp://www.timeatlas.com/5_Minute_Tips/General/Excel_AutoFilter_Makes_Spreadsheets_More_Useful