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

    MATCH help

    Thank you so much! I've been doing a LOT of excel work with my job lately and your blog has been a HUGE help. And this one issue was making me crazy.
  2. W

    MATCH help

    I am using index/match to locate the next item in a list that matches criteria. The list is showing when users in a call center are logging in and out of the phone queue. For every LOGIN in Column J, column K has a formula that should find the next LOGOUT in Column J associated with the same...
  3. W

    Sharepoint date(text) to date format

    I've been doing a lot of work with sharepoint data in excel. Its annoying that the dates in sharepoint aren't recognized as dates by excel. But I've found you can generally just use excel's DATEVALUE function. so DATEVALUE(your_sharepoint_date) will change the text only 08/20/2012 02:20:10 PM...
  4. W

    Finding change in value over specified time.

    You just need to locate the first and last date of the month and then subtract the last day's weight from the first day's. To get the first day of the month's weight use: INDEX(weight_range,MATCH(DATEVALUE("07/01/12"),date_range,0)) Then, to get the last day of the month's weight, use...
Back
Top