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

    Excel Formula

    Dear All, I have the following data that I need excel formula or any better method to do the work. DATA : Part No. 01/09 10/09 15/09 11/09 A 5 1 1 2 B 10 4 1 2 C 8 9 8 3 Summary Report : Daily Part No 01/09...
  2. L

    Excel Formula

    Dear All, I have the following data that I need excel formula or any better method to do the work. DATA : Part No. 01/09 10/09 15/09 11/09 A 5 1 1 2 B 10 4 1 2 C 8 9 8 3 Summary Report : Daily Part No...
  3. L

    Excel Formula

    Dear Sifus, I have this calculation of production time as below. Time Start Time End Total Time (Min) 8.00 17.00 =(17-8)*60 = 540 Time Start Time End Total Time (Min) 20.00 8.00 =(8-20)*60 = (720) *The result for this formula will be (720) min...
  4. L

    IFERROR function

    Dear sifu, I'm using "IFERROR" function in Excel 2010 and save as .xlsx file. Example : =IFERROR(VLOOKUP(H1,Sheet1!$C$1:$E$100,2,FALSE)," ") When I open with excel 2007 and 2003, the cell with this formula will return as #NAME. Is "IFERROR" function not available in excel 2007 & 2003...
  5. L

    Data to be sorted.

    Dear Excel Sifu, I have data that needed to be sorted as follow. Truck No. ETD ETA 33M 4080 1-Oct 6-Oct 33M 4095 1-Oct 9-Oct 33M 5035 1-Oct 9-Oct 33M 4080 5-Oct 15-Oct 33M 5035 5-Oct 16-Oct 33M 4095 5-Oct 17-Oct The above data is the delivery...
  6. L

    Excel Monthly report

    Hi, all sifu. I have a monthly report. Now, I need to prepare the monthly as at March 2011. For example : This is a table with formula : Jan Feb Mar Apr June Jul and so on.... Cost 1.00 2.00 3.00 #DIV/0! #DIV/0! How to make the error disappear? I do not...
  7. L

    Printing embedded object in excel

    How to print embedded object together with data on a spreadsheet? As the embedded chart is not appear in print preview. I'm using Excel 2007. Please help. Thank you.
Back
Top