Recent content by a_dani20

brilliantly explained narayan...now i got a hang of it...thanks a ton.. P.S: Was just wondering can we somehow use sumproduct instead of using array to produce the same result..

Hii guys... Thank you all for your fascinating solutions... Narayan's formula worked like a charm (though i didnt understand how it works), would really appreciate if Narayan can throw some light on basic functioning of this formula... Regards.. Amit

Hi Faseeh, Thanks for prompt reply.. For example Growth :- In cell H6 i need sum of all weeks of April which will be 150, similarly for Cell I6 (May) sum will be 196 and for Cell J6 (June)it will be 96. Since July Now total of April, May and june i.e 442 should come in cell D6 (Q1)...

hii guys.. I have got one file on which I update growth and outstanding on weekly basis. What i need is that on the basis of week, respective monthly and quarterly numbers should get automatically updated. There are two major issues i am facing in doing so:- 1) How to identify last non blank...

Hii sajan... Average is weighted on outstanding balance..

Hii guys... i have a file containing outstanding balance,interest rates and maturity for deposits received. Deposits are classified on the basis of there maturity period viz 0-30, 31-90, and 91-120 days. Further deposits are also categorized on the basis of there group viz retail and...

very well explained.. thanks

this is the name formula "imgHideShowDesc"

Hi guys I recently read an article on http://chandoo.org/wp/2011/04/27/update-report-filter-macro/ In this article one interesting thing i noticed was expand/collapse option using named formula.. but i was unable to understand it.. pls help??

Hi all I am looking for a formula which copies value in above cell. If above cell is blank then it goes to first non blank cell above and copy value in that cell. For eg if A1 is Smith. A2, A3 and A4 are blank. A5 is Jones. A6 is blank. A7 is Green. A8, A9, A10, A11 are blank, etc. I am...

Hi frnds.. I want to prepare a excel sheet in which i want to enter some records. There are two sheets one for data entry ( named 'source') and other containing all the data entered ( named 'master') . Now what i want is as soon i enter data in source sheet and press enter or some other...

hi guys.. i have one small problem i am using a particular formula which contains reference to particular cell ( say A1) several times ( 7-8 times) now i want to copy that formula to another sheet with reference to another cell ( say b7). For this i have to manually change all references from A1...

thanks asa and John@ReddyBay.. but there is one problem guys macro is running but it is not producing desired result. actually the macro is to calulate income tax of a person depending on type - male, female or senior citizen ( that answers John question!!) and income level of person, but the...

Hi guys.. i am trying to create a sshort macro for calculation of incometax but it is showing " type mismatch error". Pls help. Also any suggestions to improve this macro are welcome... Sub IT() Dim Incometax As single Dim ExemptionLimit As single If Range("b6") = "Male" Then...

Hi guys Can substitute formula be used to replace more than one text string?? if not how i can replace more than 1 text string in a sentence???