Thread: Is it possible?
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Soo Cheon Jheong Soo Cheon Jheong is offline
external usenet poster
  
Posts: 14
Default Is it possible?

.Range("B2:D6").Formula =
"=IF(COUNTIF($A2:A2,""?"")<Sheet1!$C2,Sheet1!$B2," """)"

== .Range("B2:D6").Formula =
"=IF(AND(COUNTIF($A2:A2,""?"")<Sheet1!$C2,Sheet1!$ A2<=B$1),Sheet1!$B2,"""")"


--
Regards,
Soo Cheon Jheong
Seoul, Korea
http://excel.hompy.com
_ _
^вп^
--


Reply With QuoteReply With Quote