Search results

It works.Thanks Faseeh :-)

I cant understand Faseeh.Can you please provide formula in excel sheet please!

Dear All, I need a summary as below by using formula. Inputs are below: Date Particulars Amount 28-09-2012 ECS/A1 abcdefgh 10000 30/09/2012 ECS/A3 asdefijgk 2000 10-10-2012 ECS/A2 peiourmfk 5000 output as below: ECS Sep-12 Oct-12 Nov-12 Dec-12 A1 10000 (Answer)...

Super Narayank991.It works. Thanks Sajan,Chandoo & Narayank991 for the support.

Can you please attach excel sheet with formula.

Dear Sajan, I cant understand the formula.Instead of creating name ranges can you please put formula for my knowledge .Thanks for the support.

Dear All, I need a formula help on allocating payment received from Customer on First cum first basis. For example, Customer Value A 100 B 125 A 110 A 285 A 300 Payment is received for A is 500.It should be allocated as below: Customer Value Payment A 100 100 B 125...

Thanks to all.Above formula works.

Dear All, I need help on identifying month based on dates. Example, 12/7/2012 - July-12 (Answer) If Date is blank,formula should also blank.

Thanks Muneer.I understand. Thanks for the support.

It working.Thanks for the support.Whats wrong in the previous formula?

I copy pasted as special which is in heading,still it is not working.Can you please check in excel.If it is working for you,can you please upload excel sheet Please!

Yes you are correct Muneer.

Dear Muneer, above vlookup formula is not working for the below case: Currency Apr-11 May-11 Jun-11 Jul-11 USD 44.2150 45.0600 44.7000 44.1900 GBP 73.6025 74.3250 71.5525 71.9650 EUR 65.7425 64.8675 64.7400 63.1450 For EUR,Apr-11 it...

Thanks Suresh.It also works,but the year comes to 2012-13.

Thanks Muneer.It works.Thanks for the support.

Sorry Debraj Roy,I think i have not propoerly explained it to you. Following are the dates and corresponding should be the answer: 07/02/2012 Q4-FY11-12 07/04/2011 Q1-FY11-12 07/07/2011 Q2-FY11-12 07/12/2011 Q3-FY11-12

Dear All, Our accounting period is from April to Mar for every year.I need a formula for Quarter based on the dates. Below is the example: 07/04/2011 Formula should be Q1-FY11-12. Thanks for the help.

Thanks Muneer.The above formula works well.

Thanks Kris :-)It works.

Dear ALL, I need to find out sales person based on the below criteria: Below is the database with Customer,Quarter-wise sales person Customer Q1 -FY2011 Q2 -FY2011 Q3 -FY2012 Q4 -FY2012 X Mr.A Mr.A Mr.B Mr.A Y Mr.C Mr.C Mr.C Mr.C Z...

It works.Great! Thanks Chandoo.

Dear All, I need a formula help to re-arrange the data Below is the input: A2 B2 1 2 Red 3 4 Green 5 Yellow,Blue,White 6 7 8 Black 9 10 11 Purple 12 Output (Formula in D2) as below: C2 D2 Red 2 Green 4 Yellow 5 Blue 5 White 5 Black 8 Purple 11 Thanks...

Thanks Kasuhik.Would 365.25 days would be fixed for all the 100 years or it will vary?

Hi all, I required a formula to arrive at exactly correct date before & after the date. Example: Date of birth :07-Aug-1983 Exact date before 12 years before birth (Answer) - 22-Jul-1971 Exact date after 4 years from birth (Answer) - 22-Jul-1987 Request your support please!