Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a 2 digit number in a cell, say 52 for instance, in A2 that I
want to display in E2 as 25, in numberical order, in other words. I have this formula that I copied to my spreadsheet: =IF(ISBLANK(A2),"",--MCONCAT(VSORT(MID(A2,INTVECTOR(LEN(A2),1), 1)+0,,1))). This works great, does exactly what I want it to. Except when I restart Excel. Then I get a Name? error. I have the Analisys Toolpak loaded and I enter the formula as an array, But everytime I restart Excel it does the same thing. Can anyone help? Is there a better way to make it work? Thanks in advance, T. |