Thread: =IF(ISNONTEXT(Sheet1!C2),(A5=A5+1),(A5=1))
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
famdamly
 
Posts: n/a
Default =IF(ISNONTEXT(Sheet1!C2),(A5=A5+1),(A5=1))

Weird, when I put text in the queried field it returns true, and vise
versa for ISTEXT, I must not understand the logic of that.


--
famdamly
------------------------------------------------------------------------
famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=492619

Reply With QuoteReply With Quote