+ Reply to Thread
Results 1 to 2 of 2

struggling

  1. #1
    Registered User
    Join Date
    10-31-2010
    Location
    clydebank, scotland
    MS-Off Ver
    Excel 2003
    Posts
    15

    Question struggling

    below is an extract from a spreadsheet showing columns P to S and I need to show the last date in P1. for e.g
    row 2 under P1 should show 29/01/2010.
    row 3 under P1 should show 11/09/2009
    row 4 under P1 should show 15/12/2009 and so on. in other words all the latest dates should be showing in column P1.

    I would be grateful for any help in this.

    P Q R S
    P1 P2 P3 P4
    24/11/2009
    26/11/2009 29/01/2010
    08/09/2009 09/09/2009
    09/09/2009 10/09/2009 11/09/2009
    17/11/2009 15/12/2009
    09/11/2009 20/11/2009 14/09/2009
    20/11/2009 14/09/2009
    14/09/2009
    10/09/2009 13/01/2010 08/02/2010 09/02/2010
    22/02/2010 30/10/2009 03/12/2009 04/12/2009
    30/10/2009 03/12/2009 04/12/2009
    03/12/2009 04/12/2009
    04/12/2009
    11/09/2009 12/02/2010
    25/11/2009
    18/12/2009 31/12/2009 01/01/2010

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: struggling

    Tomas mcD:

    Your post does not comply with Rule 1 of our Forum RULES.

    Your post title should accurately and concisely describe your problem.

    Use terms appropriate to a Google search.

    Poor thread titles will be addressed according to the OP's experience in the forum:

    If you have less than 10 posts, expect (and respond to) a request to change your thread title.

    If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title on your post, click EDIT on your first post then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

+ Reply to Thread

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