Thread: ifcount to compare two columns?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Excel Function Application Excel Function Application is offline
external usenet poster
  
Posts: 1
Default ifcount to compare two columns?
I have two columns range(A1:B1443). All I need to do is take the value of B1
and compare it to every item in column A. If this value appears in column A
at all, I would like C1 to return a value of 1, and if it does not appear I
would like C1 to return a value of 0.
Reply With QuoteReply With Quote