Results 1 to 17 of 17

Reverse Data Within Cell By Date

Threaded View

nobi Reverse Data Within Cell By... 01-09-2009, 03:48 PM
bhofsetz Did you look at why your code... 01-09-2009, 07:02 PM
nobi Thank you HTH. However, I... 01-09-2009, 07:53 PM
bhofsetz I didn't give you any code to... 01-09-2009, 07:59 PM
bstubbs I can't help with your... 01-10-2009, 09:16 AM
Leith Ross Hello nobi, I have added 2... 01-10-2009, 04:02 PM
nobi Thanks Leith!! If it helps... 01-13-2009, 01:50 PM
Leith Ross Hello nobi, It looks like... 01-13-2009, 02:11 PM
nobi Hi Leith, Its the... 01-13-2009, 02:23 PM
Leith Ross Hello nobi, Got it to... 01-13-2009, 03:53 PM
nobi Hi Leith, Need I say... 01-13-2009, 07:57 PM
nobi Hi Leith, I hope Im not... 01-20-2009, 05:45 PM
Leith Ross Hello nobi, I have added... 01-20-2009, 06:05 PM
nobi Hi Leith, Wow... thanks... 01-20-2009, 06:16 PM
nobi Hi Leith, I just wanted to... 01-21-2009, 06:28 PM
  1. #1
    Registered User
    Join Date
    01-09-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    10

    Reverse Data Within Cell By Date

    Greetings,

    I have attached an Excel spreadsheet and I will apologize now if I lose you. This spreadsheet contains two entries:

    "SwapIt" works great but will only reverse the most current date entry and list it first in the cell and the remaining date entries will remain in oldest to latest dates.

    "ReverseDates" works great but errors out with <subscript out of range> when a manual date is entered in the notes (see system created format).

    System created format; the entries within a cell will always be - MM/DD/YYYY_tt:tt:tt_AM(PM)_username (this varies) followed by the notes entered by user. So in a nutshell, the system will generate all the following but from oldest dates to latest dates toward the bottom of the cell. I would like to achieve the reverse order, latest entries to oldest entries.

    Again my apologies for rambling.

    Regards!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1