Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kim Kim is offline
external usenet poster
 
Posts: 284
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,311
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Postings ladybug Excel Discussion (Misc queries) 2 November 7th 06 08:58 PM
postings not being made bj Excel Discussion (Misc queries) 4 June 17th 05 02:11 PM
How do I find my recent postings if I can't remember title? tierneyrb Excel Discussion (Misc queries) 3 June 1st 05 06:14 PM
offensive postings bj Charts and Charting in Excel 1 May 24th 05 03:39 PM
offensive postings bj Excel Worksheet Functions 6 May 24th 05 03:27 PM


All times are GMT +1. The time now is 10:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"