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

    formula to sort times

    Thanks a lot Hui, it works. I´ve been looking for something that worked even if the table was not sorted, but I think is too complicated. It´s easy to sort the table and simplify the formula like your proposal !!
  2. R

    formula to sort times

    here is the file http://www.2shared.com/file/Eve6UHtB/Book1.html
  3. R

    formula to sort times

    Thanks Hui, I think that I've not explained myself very well... The list is as follows: (only some rows, the list has around 2000 lines) DATA HOUR 11/04/12 11/04/2012 8:09 11/04/12 11/04/2012 13:07 11/04/12 11/04/2012 13:57 11/04/12 11/04/2012 19:01 12/04/12 12/04/2012 7:59...
  4. R

    formula to sort times

    I've a table hours, it is the list of date and time when I've check in the entrance of my office. It looks like: 13/12/2011 13:43 Some days, it has 4 check in, but others can have just 1 (I've forgotten to check out), or 6, or 5... I want a formula that gives me the time number that I've...
  5. R

    min value with conditions

    It works... thank a lot Oldchippy !!
  6. R

    min value with conditions

    I dont see how... the point is that hour is always greater than zero... the array multiplication gives a result like "0/0/0/0/0/hour/0/0/0/0/hour/... "... i want to select the mininum value or hour.
  7. R

    min value with conditions

    Hi SirJB7... Ive tried... but the problem is than the min = 0, there are a lot of zeros in the array... i want the first result after 0. SMALL also doesnt work. but thanks a lot !
  8. R

    min value with conditions

    Ive a table with the entrance and exit hours of the guys in my department. But theyre a lot of entrances and exits in the same day !! I want to add a formula to detect the first and last hour each day. The table is as follows: name;date;hour; I`ve tought something as...
  9. R

    Vlookup 2 conditions, one of them the older data

    Thanks Dan_I, but the point for me it's not mess the list... I share a table data with other people and I needed a formula that didn't depend of the order of the data.
  10. R

    Vlookup 2 conditions, one of them the older data

    Astounding !! Tanks very much Hui, it's exactly what I've been looking for. I've been using array formulas with "sum", but I'm now realizing that there are some other clever uses...
  11. R

    Vlookup 2 conditions, one of them the older data

    Hi, I don't know how to find the older data in a table that also fulfill another condition: a 11-mar b 15-abr a 20-feb b 18-nov a 05-oct How can I look for the older date where the first column is an a) or a b) ??? For example, look for the older b, result 18-nov
Back
Top