Thread: Extracting data from rows where one field is blank
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pikapika13 pikapika13 is offline
external usenet poster
  
Posts: 1
Default Extracting data from rows where one field is blank

If you're trying to extract column B if C is blank (as you stated), your
formula is backwards:
=IF(ISBLANK(C23),"",B23) should be =IF(ISBLANK(C23),B23,"").


--
pikapika13
------------------------------------------------------------------------
pikapika13's Profile: http://www.excelforum.com/member.php...o&userid=10892
View this thread: http://www.excelforum.com/showthread...hreadid=570782

Reply With QuoteReply With Quote