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

Recent content by keanur

  1. K

    Fruit Calculation

    Hi Navic, Thank you so much to share your time and writing the whole explanation, very much appreciated it! i will try to understand the formula one by one and maybe i will come back and ask you further should i need some enlighten. Thank you once again. cheers
  2. K

    Fruit Calculation

    Hi Navic, Thank you for this, i can see that the formula is working. do you mind to explain further the formula, what is the function of every formula. Appreciate your feedback on this
  3. K

    Fruit Calculation

    Hi Excel Ninjas, I have a table of fruit selling. In this table there are certain categories for the customer to have different price for different booking window. Start from last minute order 1-6 days in advance will get 5% upto 90 days in advance will get 25% of Banana Master Price. I would...
  4. K

    Fruit List

    Hi Bosco, thank you for the magic :). yes, i can confirm that the formula working very well and can copy to other tabs! regards, keanur
  5. K

    Fruit List

    Hi Bosco, I almost get there, thank you so much for this. one more question, what if i extended the data up to 31st March 2020 or even further. what should I do with the formula. If use control Find and replace whatever in #67 become #500 it return to #value. Kindly advise. regards, Rico
  6. K

    Fruit List

    Hi Rahul, Hi Rahul, Thank you for Providing the lights. It works and can get my goal. i have a couple questions: - i have added more data of fruit list and extended the data upto 31st march 2020. My problem is that when I tried to extend the data capture upto row 500, the result is showing...
  7. K

    Fruit List

    Hi Peter, i tried to visualize your suggestion, but since i'm still beginner then I could not continue to get what i want he he he. but again appreciate your feedback. regards, keanur
  8. K

    Fruit List

    Hi Excel Ninja, Friendly greeting! I have one Raw data contain of Report of Fruit list that sold on Multiple months. You will see three different tab, and my expectation is to arrange the data based on monthly report. I have been trying to use different formula ie: Vlookup...
  9. K

    Converting Date

    Hi Peter, this is also a good knowledge, thank you for sharing it. have a wonderful day
  10. K

    Converting Date

    Hi Vletm, thanks for the sunshine :) i can see it now
  11. K

    Converting Date

    Dear Excel Ninjas, friendly greeting! currently i have small challenge in converting the date based on my expectation. I've been trying to find resources in google or youtube, but none have the same sample like what i have. I had attached the sample, do you mind to advise what is the proper...
  12. K

    Changing Date Format

    Thank you Hui, i got it now. its better to go to custom format and change it
  13. K

    Changing Date Format

    Thank you so much Narayan! cheers
  14. K

    Changing Date Format

    Hi Narayan, thank you for speedy respond, it almost hit to what i desired..just a small thing here, the data that i provided was based on DD/MM format while the formula showing MM/DD. would you mind to advise? thanks, KR
  15. K

    Changing Date Format

    Hi Excel Community, good morning, my name is Keanu. Recently i was trying to find a formula that can change the Date format from DD/MM to DD/MM/YY. attached is the sample of the file, the data is based on the current year 2017, however the system only showing Date and Month instead of the full...
Top