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

    Hiding rows using a drop down menu using vba

    Please share raw data with drop down so that we can give you a solution.
  2. N

    Calculating Odds

    Hi Harry, I am getting the same answer . Hope you are not following BODMAS rule. If n=69 and r=5 then the formula will be : =(FACT(C2))/(FACT(C3)*(FACT(C2-C3)))
  3. N

    Suggest alternate Formula..for large number

    Hi, Solution has been done using VBA. Write function Join_Data anywhere in excel and select then range from Q6 upto last cell and press enter then you have the city name in which 0.00 is placed. Make sure that your first row must be start from 6 or if any change then you need to go in program...
  4. N

    Drill down by click or double click on a specific column of the chart

    It can be possible with VBA to make sub menu. Do you want some specific list of sub menu ?
  5. N

    Highlight duplicate rows having same Positive & Negative Values

    Please checkout the solution of your query in which i have highlighted the duplicate cells. you can remove it or hold it as per your requirement.
  6. N

    Needed Formula

    counta(your_range)
  7. N

    using a counta formula for the sum of 2 columns side by side

    pl please send attach file . your question is not clear.
  8. N

    Formatting using DATEDIF and EXTEXT

    Hi John , please confirm that do you have your data in correct form because if the number will like this 143211 in which 32 does not belongs to any date for month.
  9. N

    Formatting using DATEDIF and EXTEXT

    Hi Basco, Text 2 Column is not work here .
  10. N

    need formula based on years

    Thanks for inform us a new formula aggregate.
  11. N

    need formula based on years

    we do not need to use different formulas. Use subtotal instead of any other formula.
  12. N

    need formula based on years

    plz find answer
  13. N

    Dates

    Hello Dear, Put this formula into cell D1 and then you will get the correct answer. =if(c1>Datevalue("03/06/2018"),c1,"")
  14. N

    How to unlock excel workbook

    you can unlock your workbook with this code:- Sub unlock_workbook() Workbooks.Open "Enter your file path here", Password:="enter your file password here", writerespassword:="enter your read/write password here" End Sub
  15. N

    Can you format cells to show height in feet and inches?

    Hi it is very easy to change cell format according to your requirement and also you can easily sort this data. Go through with my attachment. If you want any change please reply.
  16. N

    a table's name using a formula

    It can not possible to get range name via standard function. it is possible with UDF only.
  17. N

    Message when File is opened

    It is possible only by VBA code as mention below. Private Sub Workbook_Open() MsgBox ("Please do not edit this file") End Sub
  18. N

    Sumproduct or choose

    the very simple answer of this query by Index-Match function: =IFERROR(INDEX(Permanent!$B$3:$K$14,MATCH('Master sheet'!$A4,Permanent!$A$3:$A$14,0),MATCH('Master sheet'!B$3,Permanent!$B$2:$K$2,0)),INDEX(
  19. N

    Pivot table number Grouping

    Answer of Question# 3 Right Click on pivot table > click on pivot table option > select Layout & Format and unchecked "Auto fit column width on update"
  20. N

    How to build a nested IF statement to determine if # is between values

    Use this formula to get accurate answer: =IF(A2>=50,40,IF(AND(A2>=46,A2<50),30,IF(AND(A2>=42,A2<46),5,0)))
Back
Top