Thread: formula returning incorrect blanks
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default formula returning incorrect blanks
Re-read your post: land the cell pointer on your formula and press F2
to edit, then convert it to an array formula by pressing
CTRL-SHIFT-ENTER. It will then behave as expected.

Reply With QuoteReply With Quote