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

    Return last occurrence of a non blank column with certain conditions [SOLVED]

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

    Sumproduct - Weighted average interest rate (Multiple coloumn)

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

    Expand/ Collapse Cell using named range

    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??
  4. A

    Copy value in first non blank cell above

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

    Make a Form in Excel

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

    Changing cell reference

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

    Help in VBA code

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

    Substitute Formula

    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???
  9. A

    Count and Sum Simultaneously ( even in filtered rows)

    hi guys.. i am using excel 2003. Every time i select a range containing numbers i have to manually change sum status in status bar to count. i was looking for a vba function that could tell me the sum , count and average of numbers simultaneously. The vba function should also work on filtered...
  10. A

    MegaFormula in custom Menu??

    Hi guys.. Is there is anyway by which a megaformula (by combinig several formulas) to perform a specific task can be added in my custom menu without using VBA???
  11. A

    Whether a word contains any vowel

    hi guys ..Can any formula be made to know that whether a word contains any vowels or not ??? i need a formula which gives true if a word contains any of the 5 vowels otherwise it should give false.
Back
Top