View Single Post
 
Old 01-30-2017, 08:00 PM
ConfuddledOne ConfuddledOne is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Oct 2014
Posts: 10
ConfuddledOne is on a distinguished road
Question Filter by multiple columns

I have a spreadsheet that shows a persons details including 3 columns that contain their 1st, 2nd and 3rd choice of desired location (O, P and Q).

I would like to be able to filter the spreadsheet to display everyone who has selected the location in question, regardless of which of the 3 columns it is in.
Reply With Quote