Thread: pivot table - trying to find A OR B instead of A AND B
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
mo mo is offline
external usenet poster
  
Posts: 3
Default pivot table - trying to find A OR B instead of A AND B
use the locical =or fuction.

=OR(A1=PEAR,A2=PEAR) WILL RETURN TRUE IF EITHER IS TRUE.

Any help

Reply With QuoteReply With Quote