Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Postings | Excel Discussion (Misc queries) | |||
postings not being made | Excel Discussion (Misc queries) | |||
How do I find my recent postings if I can't remember title? | Excel Discussion (Misc queries) | |||
offensive postings | Charts and Charting in Excel | |||
offensive postings | Excel Worksheet Functions |