View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Array Formula and 2 Tabs!

That's due to a line break issue when you copy n paste from posts. In the
formula bar, just place your cursor on the 2nd line (that's the obvious line
break), then remove it by pressing Backspace, then ENTER. All should be ok.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dan the Man" wrote:
Hi Max!

I copied and pasted both of your suggestions and got a: #REF! error result
:(. HELP!