Search results

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.

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

I'm taking about excel 2010.

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

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

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

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

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

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

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

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

Hi Luke, How would you do a second filter after the first one? let's take my first example: filter#1 : >=10 OR <=2. The first result is 8:04. Then how can I filter the rest of the data with this filter: <= -2 or >=4? The result should be 8:07. Thank you. 8:00 4 8:01 5...

Hi Luke, How would you do a second filter after the first one? let's take my first example: filter#1 : >=10 OR <=2. The first result is 8:04. Then how can I filter the rest of the data with this filter: <= -2 or >=4? The result should be 8:07. Thank you. 8:00 4 8:01 5...

It is ok. I just forgot the Ctrl,Shift, enter... Thanks again, Cold

Hi again, I just realized that it is not working perfectly for what I want to do. If I use this example I should get 8:01 instead of 8:04 but it still shows 8:04. Can you please tell me why? Thank you 8:00 4 8:01 6 8:02 4 8:03 3 8:04 2 8:05 1 8:06 2 8:07 5 8:08 6

Hi Luke, I have no idea how you did it but it is working! I'm so glad I don't have to do macros. I tried the formula you gave me and it is working. Thank you so much, Warm regards,

Hi, I would like to autofilter data from 1 column with a formula. It is a double filter : greater or equals to 6 OR less or equal to 2. Column A (time),column B (data) Column A Column B 8:00 4 8:01 5 8:02 4 8:03 3 8:04 2 8:05 1 8:06 2...

Hi, I'm looking for a more powerful shreadsheet than Excel 2010. I think the maximum number of rows in Excel 2010 is 33,000. I would need to work with 50 million rows within the same spreadsheet. Thank you