Thread: countif function: how to distinguish case/make case sensitive
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mvwoolner mvwoolner is offline
external usenet poster
  
Posts: 1
Default countif function: how to distinguish case/make case sensitive
Is there a way to make the countif function case sensitive? If cell A1 has a
'c' in it and cell a2 has a 'C' in it, how can I make =countif(A1:A2,'C')
give the value 1?
Reply With QuoteReply With Quote