Hi, Add an helper column to your data Insert column after column 2 and there put =IF(A2="cat","Cat",IF(B2="cat","Cat","")) This will put a "Cat" if there is "cat" in column1 or column2 then you can base your pivot table on this column to get your solution.
Hope that helps, Anand Kumar On Jan 14, 2:23 am, "Omar" <omar27...@gmail.com> wrote: > I have a pivot table > > how to use " Or" in two columns > > I want to view all rows which > > Column1 = "cat" Or column2 = "cat" > > Not > > Column1 = "cat" AND column2 = "cat" > > By code or any way > > Thanks! -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
