• 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

    Cell Clears When Not Desired

    Simple. After pressing F2, if I cancel the operation and the original content reappears, it means sheet is protected and cell property is hidden.
  2. N

    Cell Clears When Not Desired

    You have defined cell D10 as hidden cell. Unprotect the Sheet. Go to cell properties of D10 by clicking that cell and pressing Ctrl+1 and remove the hidden option in the cell. This will solve the problem.
  3. N

    Macro to create PDF and save file

    First Query already answered by Nebu. Second Query : 1. You have to save the file before publishing as pdf. Save the file before creating pdf. 2. The file name path you have given in the macro should be already available. If you take care of the above, there will not be any debug error.
  4. N

    Extract data from other sheet

    Enclosed the solved file. with best regards Arun N
  5. N

    2 files -compare costs for same date and same person ID

    A small change, instead of first "Not found", it should be "Not Matched". The formula will be =IFERROR(IF(ABS(F2-INDEX('File 2 '!$C$2:$C$16,MATCH(1,MMULT((A2='File 2 '!$A$2:$A$16)*(C2='File 2 '!$B$2:$B$16),1),0)))/F2<0.1,"Matched","Not Matched"),"Not Found") with best regards Arun N
  6. N

    2 files -compare costs for same date and same person ID

    Enclosed the file with tolerance. with best regards Arun N
  7. N

    2 files -compare costs for same date and same person ID

    Hi Enclosed the file. Alter few data to check. with best regards Arun Do you like the formula or any additional requirements?
  8. N

    2013 Excel Restarting - Pivot Table

    When you name the table as Table1, the source range of Pivot tables to be changed to Table1 and not Pivot1. with best regards Arun N
  9. N

    COPY date from Sheet 1 to another 15 mins work sheet

    Open both files. Type the following formula in J2 and copy it down. =IFERROR(INDEX([Sheet1.xlsx]Sheet1!$M$2:$M$693,MATCH(A2&B2,[Sheet1.xlsx]Sheet1!$A$2:$A$693&[Sheet1.xlsx]Sheet1!$B$2:$B$693,0)),"") Control+Shift+Enter(CSE). with best regards Arun N
  10. N

    COPY date from Sheet 1 to another 15 mins work sheet

    In the sheets provided by you, there is not even one row where date and symbol matches. Please check. with best regards Arun N
  11. N

    COPY date from Sheet 1 to another 15 mins work sheet

    Seems symbols and dates in both files are mutually exclusive. i.e., there are no rows matching. Hence the result will be, no rows will be copied. with best regards Arun N
  12. N

    Table track updates

    Hi Check whether the code in enclosed file helps. with best regards Arun N
  13. N

    Extract data from other sheet

    If you want the column B to extract all employees, I have enclosed the file to extract all the employees available. with best regards Arun N
  14. N

    Extract data from other sheet

    Enclosed file as per your requirement. with best regards Arun N
  15. N

    Auto Populated list

    Nice Formula. However, the above formula does not take into consideration of drop down List. Enclosed the solved file for your reference. Hope this will solve the issue. with best regards Arun N
  16. N

    Extract data from other sheet

    Dear IKHAN Define Range Name for 2016 as E_2016. Define Range Name for 2017 as E_2017. Data Validation is List at =INDIRECT("E_"&A10) Enclosed example file. with best regards Arun N
  17. N

    Action upon data validation

    Hello, Welcome to the Forum. I request you to clearly define the problem. Row1,Col1 seems to have 3 options with Age range only and not particular age. You are comparing exact age in Row1, Col2. We cannot compare. Will you be able to enclose any file to explain this. with best regards Arun N
  18. N

    Nested if statements

    Observing the code, I have few observations, When you choose 2016 or 2017, it is a number and what you are comparing is a string. Hence, if you choose those options, the related code will not run. store those values i.e., 2016 and 2017 as text in the sheet [Control]. When you choose "All...
  19. N

    Find the minimum every line, and summarize 2

    A simple function for 3 columns. =SUM(IF(IF(A1:A10<B1:B10,A1:A10,B1:B10)<C1:C10,IF(A1:A10<B1:B10,A1:A10,B1:B10),C1:C10)) A simple function for 4 columns. =SUM(IF(IF(A1:A10<B1:B10,A1:A10,B1:B10)<IF(C1:C10<C1:C10,C1:C10,D1:D10),IF(A1:A10<B1:B10,A1:A10,B1:B10),IF(C1:C10<D1:D10,C1:C10,D1:D10)))...
  20. N

    Nested if statements

    In the case of All months, just clear the filter. Criteria may not be <>. In case of 2016 or 2017. Try Disabling months filter and filter based on year. Hope this helps. with best regards Arun N
  21. N

    OR Criteria in CountIfs

    =SUMPRODUCT((A2:A7="Apple")*(SUMPRODUCT(((B2:D7="Green")*1))>0)*1) The above formula is not giving the results, check by deleting the "green" in H2 in 5th data row. It simply counts and do not check row by row. The more accurate formula may be...
  22. N

    Multiple IF statements referencing a data validation list

    Please check the enclosed file. Hope this helps. with best regards Arun N
  23. N

    Find the minimum every line, and summarize.

    A simple function for 3 columns. =SUM(IF(IF(A1:A10<B1:B10,A1:A10,B1:B10)<C1:C10,IF(A1:A10<B1:B10,A1:A10,B1:B10),C1:C10)) A simple function for 4 columns. =SUM(IF(IF(A1:A10<B1:B10,A1:A10,B1:B10)<IF(C1:C10<C1:C10,C1:C10,D1:D10),IF(A1:A10<B1:B10,A1:A10,B1:B10),IF(C1:C10<D1:D10,C1:C10,D1:D10)))...
  24. N

    Dynamic Ranking Question

    Hi Enclosed the solution. with best regards, Arun N
  25. N

    2 files -compare costs for same date and same person ID

    Hi Enclosed the File. Hope it helps. with best regards Arun N
Back
Top