Search results

Sorry, my mistake. The Part No. in data sheet in not the same order as the summary report.

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

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

Thank you all sifus....

Thanks for the solution. One more problem. If I have a elapsed time as below : Start End Different 20:00pm 3:00am 7 hours If I use formula as : =ABS((3:00-20:00)*24)) It will show 17 hours instead of 7 hours. As I need to fix the calculation from End time to...

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

Dear Sifu, I had tried the formula as mentioned by NARAYANK991. When I key in the formula and enter, Excel prompt up the message as below : "You've entered too many arguments for this function." "To get help with this function, click OK to close this message. Then click the Insert Function...

Hi, SirJB7 I was trying the formula as you suggested, but I just can't get it right. =IF(ISERROR(VLOOKUP(H1,Sheet1!$C$1:$E$100,2,FALSE)," ",VALUE) Is this formula correct? Please help.... Thank you.

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

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

Thanks Hui for your help....

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

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.