• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. E

    1st and 2nd Units Dates & Times for Police Responses

    Hi All, I’ve got a bit of a challenge on my hands, and wondered if you could help. I have a long (300K rows) list of police responses, where I need to identify the 1st earliest and 2nd earliest OnScene and Enroute date/times out of all units responding for each incident. I’ve included a...
  2. E

    Screwy Cells

    Hey Folks, I reuse a couple of spreadsheets every day; both of which are supplied with new data each day. The problem I'm having now is that Excel isn't updating the results of my calculations. So for example if the first cell in the column is calculated as 123, and I double click the handle...
  3. E

    Search for non-specific Text or numbers in a text cell.

    Hi Chandoo, Congratulations on the new Twins! I need a formula or method to pull out some very specific text from a cell. Here's an example: [9/25: 12345678 1234ABCD This is a test to see if I can find a better way.] I just want to pull out the 12345678 and the 1234ABCD into their own...
Back
Top