![]() |
recent postings not seen
I submitted a question earlier this morning (6/7) and received a message
saying someone had responded, but I am not able to see any postings after 6/5. What is the problem? |
recent postings not seen
I don't know if you see your post now, but the response was as follows:
It would have helped, you know, if you had also shown how you would expect them to be sorted. I assume that you want 12345 to be sorted as if it was 54321? If so, use the following formula next to your data (assuming start from A2). =SUMPRODUCT(MID(A2,ROW(INDIRECT("1:"&LEN(A2))), 1)*10^(ROW(INDIRECT("1:"&LEN(A2)))-1)) Sort by this column. HTH Kostis Vezerides Regards, Paul "Kim" wrote in message ... I submitted a question earlier this morning (6/7) and received a message saying someone had responded, but I am not able to see any postings after 6/5. What is the problem? |
All times are GMT +1. The time now is 04:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com