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

    I need a formula for two validations to show results

    Thank you for your help p45cal, I only changed the month of January, but it will be selected every month, I know that other months gave errors It could be the Excel 2016 formula, I'll change it to other months later
  2. deciog

    I need a formula for two validations to show results

    Good morning In the Summary % worksheet I need this formula I need to bring the Income through the month and company selected list validations. Average cover Investment for cell F or cell I depending on the Company and the month Other information is in Brazilian Portuguese Holidays are in...
  3. deciog

    Move value to formula result

    Gentlemen, thank you for your help. I noticed that it is not possible to move a value by cell address Thank you for your time to help Consider this doubt closed Thank you very much Décio
  4. deciog

    Move value to formula result

    First thanks for the reply. What I need is to put value in cell $M$4 example value $125.32 look example only by formula It is possible? Decio
  5. deciog

    Move value to formula result

    I have the calculated address of a cell, with the ADDRESS formula, how do I put a value directly in that cell? It is possible, only in formula, Version 2016 and 365 Decio
  6. deciog

    Extract multiple numbers from string excel use formula

    Bosco, Good morning. Excellent, I'm learning a lot, this is great Thank you very much a big hug Decio
  7. deciog

    Select only words with an accent

    Bosco That's why I like this forum. I learn a lot from you, Bosco thank you very much for your dedication and the humility of teaching. A strong hug Decio
  8. deciog

    Select only words with an accent

    Bosco, good morning. It also worked perfectly Thanks Peter, Good morning. I really enjoyed seeing the sequence for the solution of the result Worked perfectly Thanks Decio
  9. deciog

    Select only words with an accent

    Bosco I didn't know this ENCODEURL function, it's great, Thank you very much, it worked perfectly A big hug Decio
  10. deciog

    Select only words with an accent

    Gentlemen, good morning. I need all accented words from this column to be extracted and copied to another adjacent column as per Template Important only in formulas. Thank you very much in advance Hugs
  11. deciog

    how to split data into columns between [ ] when there can be more than

    bosco_yip Good morning. I hope you're overcoming all this, I'm together thinking positive for your progress and recovery, now you can notice that in this 2021 version no need to type anymore CTRL+SHIFT+ENTER anymore. A big hugs Decio
  12. deciog

    find/replace with *formula values*

    jneiblas Another way is to format all the cells that you don't want result with zeros with custom formatting Simple example 0; -0;; @ or not show zeros in the result in hours hh:mm;;"" Decio
  13. deciog

    Transpose Data with Criterion

    Bosco, good morning. It worked perfectly, thanks for the help Hugs Decio
  14. deciog

    Transpose Data with Criterion

    John Jairo V I ask you to attach the model with the formula, so Excel itself will convert the formula. Example of formula in English VLOOKUP and in Portuguese Brazil automatically translated by Excel is PROCV So I believe that if you put the model Excel will automatically convert the VSTACK...
  15. deciog

    Transpose Data with Criterion

    p45cal It worked perfectly for Excel 365 version thanks I also need for Excel 2016 version I have more than 20 sheets with this version John Jairo V In my version of Excel 365 it doesn't have this VSTACK function I'll wait for a soft update but I saved this formula, Thank you I also need...
  16. deciog

    Transpose Data with Criterion

    Good Morning. I didn't find a way to do this solution according to the attached spreadsheet I need it in non-VBA non Power Bi formulas non table. It can be Excel version 2016 or 365 thank you in advance
  17. deciog

    Numerical sequence between empty cells

    Peter Bartholomew, Good Morning. Very good formula, I learned one more, thanks for sharing experience Hugs
  18. deciog

    Numerical sequence between empty cells

    S P P, good morning. Check if this is how you want it, without auxiliary column I put the formula in cell S3 Decio
  19. deciog

    Function to remove duplicate numbers in a single cell sorting ascending order

    Ken U, Good morning. Worked, thank you. p45cal, Good Morning It worked thank you. bosco_yip, Good Morning, You are correct some versions do not have this function, your solution also worked thank you very much. Decio
  20. deciog

    Function to remove duplicate numbers in a single cell sorting ascending order

    Gentlemen, good morning. I can't solve it, I ask for your help, explanation in the model Remembering I need formula for version of Excel 2016 and also for version 365 Not VBA and not Power BI thanks in advance Decio
  21. deciog

    Find out the word how many time used in essay

    No post #18 eu respondi a versão do Excel
  22. deciog

    Find out the word how many time used in essay

    Cecilrodgers, Good morning. Check your version of Excel because it only works on version 365 2021 or higher Decio
  23. deciog

    Create Code Sequence

    bosco_yip, Bom Dia. This formula is also excellent works perfectly and faster Thank you very much Decio
  24. deciog

    Create Code Sequence

    p45cal With the template attached, the formula was translated and I loved it because it has a lot of features. In English ARRAYTOTEXT translated to Portuguese Brazil MATRIZPARATEXTO Worked perfectly Thanks
Back
Top