+ Reply to Thread
Results 1 to 4 of 4

Fire Apparatus

  1. 03-05-2016, 01:25 PM #1
    dfdparamedic
    dfdparamedic is offline
    Registered User
    Join Date
    03-05-2016
    Location
    Andover, NH
    MS-Off Ver
    2013
    Posts
    2

    Fire Apparatus

    I have a problem. I'm trying to rank a fire apparatus in the order in which they got on scene. Cell D2 is a concatenated A2 and C2, then I sorted them by column D. I'm trying to make column E work but can't seem to make it happen. Any help would be greatly appreciated. Thank you!


    A B C D E
    1 ID Appartus Resp. Time(sec) Sort Order Order
    2 103 MEDIC1 159 103-159 1
    3 104 E1 288 104-288 1
    4 104 TRUCK4 477 104-477 2
    5 104 E3 515 104-514 3
    6 121 E1 129 121-128 1
    7 121 CAR1 142 121-141 2
    8 121 MEDIC1 201 121-200 3
    9 121 E3 293 121-292 4
    10 121 TRUCK4 300 121-299 5
    Reply With QuoteRegister To Reply
  2. 03-05-2016, 01:53 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Fire Apparatus

    Why not just sort by time?

    What's the point of the catenation?

    Cell D2 is a concatenated A2 and C2
    Not in your example on lines 5 to 10.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 03-05-2016, 02:00 PM #3
    dfdparamedic
    dfdparamedic is offline
    Registered User
    Join Date
    03-05-2016
    Location
    Andover, NH
    MS-Off Ver
    2013
    Posts
    2

    Re: Fire Apparatus

    When I concatenate the two cells, they give me the order in which they arrived, but I need column E to say this apparatus was 1st due, 2nd due...
    Reply With QuoteRegister To Reply
  4. 03-05-2016, 02:13 PM #4
    FDibbins
    FDibbins is online now
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Fire Apparatus

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

    Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

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

    (note: this change is not optional )
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Fire up Worksheet_Change
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-30-2014, 12:28 PM
  2. Worksheet_change doesn't fire
    By passant6 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-19-2011, 09:05 AM
  3. can't get calculate event to fire vba
    By Cicada in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-18-2010, 06:47 AM
  4. fire a macro if a cell gets a value > 0
    By Cboggie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-16-2010, 09:36 AM
  5. Need help for fire department
    By sta224ffemt in forum Excel General
    Replies: 2
    Last Post: 12-11-2006, 04:16 PM
  6. SheetChange fire UDF unintentionally
    By Peter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-21-2006, 10:15 AM
  7. [SOLVED] Code will not fire
    By Ray A in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-01-2006, 01:45 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1