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

    How to SEARCH for more than one word/text/phrase?

    one more option... =IF(AND(H2=50,IFERROR(IF(ISNUMBER(MATCH(9,99E+307,SEARCH({"*OSS*","*Swap*","*Unit*"},J2))),1,)>0,0)),50,0)
  2. V

    Naming the Header of table based on Grouping & ungrouping

    Hi, Is this what you are looking for?
  3. V

    How to get the count of unique row labels in Pivot Table

    Hi, Check this proposal.
  4. V

    data transpose

    Try the TRANSPOSE() function.
  5. V

    Partial Text Color Change in Cell - formula

    If VBA allowed then here is an approach.
  6. V

    Gear wheel chart

    Thank you the feedbacks!
  7. V

    Gear wheel chart

    Hi, I would need your help to create a gear wheel chart, please see the sample picture in the attached file. Thank you for all your guidance!
  8. V

    LOOKUP function where value is more than one time

    Hi, Here is an other approach.
  9. V

    Remove special characters from cells.

    Hi, Check this file. The question 3 is not enough clear for me, could you please describe it?
  10. V

    How to have a dynamic sum function

    Hi, The "Item" in merged cells, if it's possible then un-merge them -> insert Table -> and use SUMIFS function. Check the attached file.
  11. V

    Calculate number of days from in Locationfrom Entry

    Hi, I would have one remark: take care with the blank cells (in date columns) in the formulas. I attached my proposal.
  12. V

    Count et All

    Hi, If you want to count the "occurrences" in cell then check this approach.
  13. V

    Sort & Filter

    Hi, The problem is not appear on my side but may be you have an issue with the number of Undo levels. Here is some support how to modify this level: https://support.microsoft.com/en-us/kb/211922
  14. V

    Sort & Filter

    Hi, Hmmm... It's sounds strange because as written on the Excel 2007 support page: "Once you have filtered or sorted data in a range of cells or table column, you can either reapply a filter or sort to get up-to-date results, or clear a filter to redisplay all of the data."...
  15. V

    Auto-insert Column or Row to a Table

    Hi, Enable the function: "Include new rows and columns in table", try this: File -> Excel Options -> Proofing -> AutoCorrect Options -> AutoFormat As You Type -> Apply As You Work
  16. V

    Excel formula to copy data from one sheet to another sheet in same workbook

    Hi, If the VBA is allowed for you then check this approach.
  17. V

    Find the Value

    Hi Narend, Q2: if you want to sum the Sales and Bonus (based on the criterias) in 1 formula then check this approach.
  18. V

    Formula to pull data that is within parenthesis in a field?

    Hi, Check this.
  19. V

    comparing cells with their spelling

    Hi, Try this.
  20. V

    comparing cells with their spelling

    Hi, Check this file.
  21. V

    Help on an OR formula

    Hi, Is this what you are looking for?
  22. V

    Find Replace Around Reference

    Hi, Try this: press CTRL+H -> at the left bottom corner there's a Look in: Formulas.
  23. V

    Formula - Combination of Numbers

    Hi, Check this post: http://www.excelforum.com/excel-new-users-basics/831717-need-help-on-4-digit-number-permutations.html
  24. V

    Changing drop down range

    I'm glad I could help to you. The part of your "thank you msg" goes to @SirJB7... he is inactive since many months but anyhow... may be he see this
  25. V

    error msg show

    Hi, If you want to avoid this msg, try this: Goto File upper left corner -> Options -> Trust Center -> Trust Center Settings -> Privacy Options -> un-check the box that have Remove personal information from file properties on save > OK
Back
Top