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

    How to make cell pattern and colour in diagonal

    No. The cell have some data. If possible, then I will make the condition format to make colour the diagonal portion.
  2. Kutty

    How to make cell pattern and colour in diagonal

    I try to fill within cell diagonal line
  3. Kutty

    How to make cell pattern and colour in diagonal

    Is there any other options without code
  4. Kutty

    How to Fill the Number up to maximum repetition with certain Timing conditions

    Hai Friends, How to fill the number up to particular repetition with more than 3 conditions (including Time also). I attached herewith my excel file for your reference. Thanks & Regards, Kutty
  5. Kutty

    How to make drop down list except the selected name in the particular cell

    Thank You So much @Luke M for your help. It's very helpful to me. You done exactly what I want. Thanks a lot. by Kutty
  6. Kutty

    How to make drop down list except the selected name in the particular cell

    Hai Excel Experts! How to make drop down list in many rows except the selected name in the previous cells. I attached herewith my excel file for your reference. Thanks. by Kutty
  7. Kutty

    Picture Lookup

    Hi Chihiro Thank You so much. Your work sheet is so helpful to me. I don't know VBA. But here after I would like to learn. Thanks a lot.
  8. Kutty

    Picture Lookup

    Hi bosco_yip Thanks for your workout. It has so many named range. I have try to avoid many named formula. If above 500 bio-data and Photo, it may not possible. That is why I am asking any other method to eliminate so many named formula. Thanks
  9. Kutty

    Picture Lookup

    Hi Chihiro I accept it. Thanks.
  10. Kutty

    Picture Lookup

    Hi @Peter Bartholomew This one is what i want. I think without VBA its impossible.. :confused: Thanks for sharing this spreadsheet.
  11. Kutty

    Picture Lookup

    Hi Peter I'm not understand your formula
  12. Kutty

    Picture Lookup

    Hi @Chihiro Sorry for that inconvenient. Here it is the sample file.
  13. Kutty

    Picture Lookup

    Hi! I retrieve picture, using Index & Match functions. I have picture data in one sheet & contact details in another sheet. If we retrieve the picture in one row it may possible. But I want picture so many rows. It may be want so many named range. Is there any other way to do solve this problem?
  14. Kutty

    Answer for "Find out if a number has repetitive digits" Formula Home work

    I'm surprised to see everybody posting their formula in different view. Thanks to Excel Ninjas.
  15. Kutty

    Answer for "Find out if a number has repetitive digits" Formula Home work

    This post is a response to the previously asked question. But mine is without array formula. https://chandoo.org/wp/2017/10/03/number-has-repetitive-digits-formula/
  16. Kutty

    Answer for "Find out if a number has repetitive digits" Formula Home work

    I think it will help you to understand clearly
  17. Kutty

    Answer for "Find out if a number has repetitive digits" Formula Home work

    is this correct or not...
  18. Kutty

    Sum of Particular product in particular month

    Thanks @haseeb Avarakkan
  19. Kutty

    Sum of Particular product in particular month

    Thanks @Rahul Shewale It's useful to me. Now my doubt is cleared.
  20. Kutty

    Sum of Particular product in particular month

    I expect this type of formula with particular product https://stackoverflow.com/questions/15285381/excel-formula-to-sumif-date-falls-in-particular-month
  21. Kutty

    Sum of Particular product in particular month

    Sry. I don't want pivot table.
  22. Kutty

    Sum of Particular product in particular month

    Hai Friends! I want to sum the particular product in particular month. Please suggest one of the excel formula.
  23. Kutty

    Is this possible in MS Excel Chart?

    Thank U @xlstime , but there is no 3D row view in excel like above chart
Back
Top