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

Recent content by cold

  1. C

    easy way to paste a worksheet on multiple others

    Thank you for your advices. I don't think access is a good choice for me since I'm using a lot of formulas (vlookups, match...). I will paste my original sheet one at the time over 10-15 sheets and split over many files.
  2. C

    easy way to paste a worksheet on multiple others

    Hi, I would like to know if there is an easy and sure way to paste a worksheet on multiple others. My original sheet is 80,000 rows x 32 columns and I would need to paste it on 280 others sheets within the same excel file. I tried to group 280 sheets and paste them all at once but it failed...
  3. C

    maximum worksheet in one excel file

    I'm taking about excel 2010.
  4. C

    maximum worksheet in one excel file

    Hi, I would like to know what is the maximum number of worksheets in one excel file. I know that the maximum number of rows is about 1 million but is it per worksheet? Thank you
  5. C

    vlookup with time

    I could shift the column B but I'm afraid to get confuse in the long run. I will stick with =FLOOR(A2,"01:00") and add one extra column. Thank you all
  6. C

    vlookup with time

    It is working only when the vlookup value is higher than the first time point. In the example just above I will get no result if the vlookup value is 8:00:00 but I will get 12 (desired valued) if the vlookup value is 8:03:00. Is there a way that the vlookup (True arguement) searches higer...
  7. C

    vlookup with time

    Both ways are working. Thank you In fact what I Ideally want to do is to do a vlookup on column A (time) and get the column B value BUT the vlookup value i'm chasing is always round time points (ex: 8:00:00, 9:00:00...). In the example below the vlookup value would be 8:00:00 and I wish to get...
  8. C

    vlookup with time

    Hi all, I have a column with increasing time points 8:01:00 8:02:02 8:03:09 ... 9:05:01 9:06:55... I would like to round them down to the earliest and smaller time point: 8:00:00 8:00:00 8:00:00 ... 9:00:00 9:00:00... Thank you
  9. C

    vlookup with time

    You are right. Is there a way to round down time? 8:01:06 to 8:00:00 Thank you
  10. C

    vlookup with time

    Hi, Is there a way to use V Lookup with time as lookup value? 8:00:00 12 8:00:01 14 8:00:02 18 Thank you
  11. C

    create a new table automatically from the original with a formula

    Hi, I would like to know how I could create a new table from an original one. 8:00 2 8:01 3 8:03 4 8:04 5 8:05 6 Let's say that I want to create a new table that starts from 8:03. I need to do it automatically (with a formula). Thank you
See more
Back
Top