ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   recent postings not seen (https://www.excelbanter.com/excel-worksheet-functions/145635-recent-postings-not-seen.html)

Kim

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?

PCLIVE

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