Results 1 to 7 of 7

How to tell the order in which an event occurred?

Threaded View

  1. #1
    Registered User
    Join Date
    03-31-2011
    Location
    Mexico
    MS-Off Ver
    Excel 2007
    Posts
    4

    How to tell the order in which an event occurred?

    Good day!
    please look at the attached excel.
    Each row describes a document and the times when a revision for the document occured.
    Column H specifies the number of revissions.

    Columns C,D,E,F,G specifies the time when a revission occurred. If the column is 1, this is the first revission occurred. Then, the maximum value in each row describes the time when the last revission occurred. When there is no value in any column, it means that no such event occurred for that particular row.

    What I am trying to do is to order in columns K, L, M, N, O, in which order did each event occur.

    For example, Row 4 is correct with its current formula, but row 18 should be 1,2,3,4,5 (or 1,2,4,3,5, since revissions C & D occurred the same day)

    Getting the first & last is easy (I can use MAX & MIN formulas) but getting the middles is what I am finding hard to do.

    How would you do it?
    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