View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
alexcn alexcn is offline
external usenet poster
 
Posts: 5
Default Morefunc ARRAY.JOIN function

Hey there,

Has anyone experienced the ARRAY.JOIN function producing different
results (when combined WITHIN the UNIQUEVALUES function) when used in
the same workbook, but opened on different computers all using the
same OS (Windows XP) and the same version of Excel (2007 with all
updates installed)

I have four different systems accessing the same workbook, and on
three of them it produces the same textual results correctly, but on
the fourth it seems to return an array of excel dates (even though the
formula remains the same and combines too named ranges into one then
selects the unique values on this)

Any help would be greatly appreciated,

Many thanks,

Alex