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
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
