Thread: Determine a result of one column based on conditions in two column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tel703 tel703 is offline
external usenet poster
  
Posts: 1
Default Determine a result of one column based on conditions in two column
Example
Col A Col B Count the number of a's in Col B only when an x is in
Col A
x a
x a Result should be 2
y a
z p I can't figure it out
x t
x m Thanks
Reply With QuoteReply With Quote