• 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. O

    Shortcut to select contents of a cell

    Dear members, I was wondering if there is a shortcut to select the contents of a cell, and this is very important, when you inside the cell. For example, I have a cell with a long strings of words and I could press F2 and Shift + <-- to select the contents, but when I have many cells to go...
  2. O

    Extract a value from an array of cells

    Dear members, I have a problem - I am trying to extract a value from a range of cells and I would like you to help me with the formula. I want to take the range of 5 cells (see the attached spreadsheet) in which only one has a value (and others do not) and extract that value into another cell...
  3. O

    Formula to subtract time in a specific format

    Hi I have a problem with figuring an appropriate formula to subtract time. Suppose I have a time in mm:ss format showing 05:01 (meaning 5 minutes and 1 second) in A1. In A2, the column "Slow", need to have a formula, if the time in A1 is less than [specified time] say, 2 min, then return "No"...
Back
Top