View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ForSale[_61_] ForSale[_61_] is offline
external usenet poster
 
Posts: 1
Default =Count(two "n" in a row, c3:ad3)


I need a formula similar to the one in the subject, i know that won't
work though. In each row is a series of "y"s and "n"s. I need to know
if there are two "n"s in a row.
Thanks,


--
ForSale
------------------------------------------------------------------------
ForSale's Profile: http://www.excelforum.com/member.php...o&userid=11896
View this thread: http://www.excelforum.com/showthread...hreadid=509129