Search results

I follow your instructions by creating the dates on another worksheet and save it as test.xls. But when i type in the function you had written for me earlier,it gave me an error message stating that MS excel cannot file 'datacolumn' on test.xls. Can you show me my mistakes please ? Thanks.

Hi dan, thanks for your reply. Do u mean i create the data of the maturity date and the amount and save it into another excel file and then open a new excel file and key in the function you had written for me ? You also suggested me to use a pivot table, may I know how do i go about doing it? I...

Thank you for your reply. If i use sumif function, i can set the range but how do i set the particular date ? Can u show me how to write the function or not ? Thanks again.

I have a table of data on the maturity date of some trading deals. May I know how can i classified those trading deals with the same maturity date together ? For example: 02 oct 2011 100 25 nov 2011 20 02 oct 2011 400 17 dec 2011 1000 03 jan 2012...

Hi Luke, thank you very much for your patient for guiding me how to solve my problem. I finally managed to generate the correct figures. I hope to learn from you in the future. Nice to know you too.

Thanks Luke again. But when I try using the command you written for me(using the Datevalue function), it generate as 9-Apr-00, and not the value 100. Sorry for my ignorance, do you mind pointing out my mistake again ? Thanks again for giving advices to me.

Hi Luke, is the formula written as =sumif(A:A,">="&01-Sep-11,B:B)-sumif(A:A,">"07-Sep-11,B:B) ?-(For period within 7 days of the month) But the answer generated out is 00-Jan-00, may I know what is reason ? And may I know what do you mean by boundary markers and how can I make use of...

Hi Hui, thank you for your reply. Do u mean I need to convert the date into days first ? For example: Name Mat date Amt Mary 02 Sep 2011 100 John 15 Oct 2012 3000 May 23 Dec 2011 200 Hong 15 Jan 2012 500 Yen 28 Sep 2011 400 I need to classified...

Hi Luke, thank you very much for your guidance, I finally able to do the table. May I ask you for another question ? This time the number of days is changed to Date (ddmmyy), may I know is it possible for me to use the above formula you taught me ? Thanks again.

Thank you Hui for your reply. I am sorry i still dont really understand how to use privot table or sumproduct to do my report. For example, I have a range of data that look like this : I need to classified the total amount according to the number of days, from 1 to 31 days, 32 to 91 days, 92 to...

I have a report on time deposits where I need to classified according to number of days. For example for 1 to 7 days, 7 days to 1 month, 1 mth to 3 mth etc. Now i am using Data-filter to arrange the maturity date and then i manually classified according to the different category and then add the...