• 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. 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
  2. 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
  3. 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...
  4. 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
  5. 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...
  6. K

    Converting Date

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

    Converting Date

    Hi Vletm, thanks for the sunshine :) i can see it now
  8. 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...
  9. K

    Changing Date Format

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

    Changing Date Format

    Thank you so much Narayan! cheers
  11. 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
  12. 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...
  13. K

    Combining Formula to look up in different excel tab

    Hi Hui, Perfecto :), thanks so much for your swift respond. I can do it now Cheers, Rico
  14. K

    Combining Formula to look up in different excel tab

    Hi Excel Ninjas, recently i work on excel template, and there is a challenge when i want to use a proper formula for the specific column (Total Sell Revenue) in Pick Up Report Tab. basically, what i want to do is a simple formula that can look up at Total sell revenue on Database Tab. However...
  15. K

    Formula does not work

    Hi Hui, Thanks for the advice, it works now :) cheers, keanur
  16. K

    Formula does not work

    Hi Excel Ninjas, I have a small challenge, where as excel formula is not given any result. i have attached the sample. I put formula on cell A5 and copy it across A20 and still give result of 2. Would you advice on how i supposed to do on this. Thanks, Keanur
  17. K

    Suggestion :Case Category

    Dear Admin and excel Ninjas, i'm happy to join this group since last year as it gives more knowledge about excel. i was thinking whether admin group can categorize the case base on the user skill (Beginner, Intermediate, and advance), this will help the user to find out the case based on...
  18. K

    Combining Name [SOLVED]

    Hi Hui, Thanks for grant it within few minutes. have a nice day! Keanur
  19. K

    Combining Name [SOLVED]

    Good Day excel Ninja, i want to ask you a question: I have table which contain First name on Cell A1 and Last name on B1, now i want to combine this A1 & B1 as the result for C1. do you know what is the best and simple way to do it in excel. thanks in advance. warm regards, Keanur
  20. K

    Finding DOB

    @ SirJB7, yes, i will visit my email and reply once i have a chance to see it. Thanks bro! keanur
  21. K

    Finding DOB

    Dear Dave, it is simple and great result, my case is resolved. Thank you man Dear Narayank991 cool formula, i have tried the formula. thanks Dear Bobhc, appreciate your link and advice Regards, keanur
  22. K

    Finding DOB

    Hi Narayank991, i tried on my excel sheet, but still not come up with the proper result. column E2 return to value (1) while E3 and soon return with #NUM. can you elaborate a little bit, i'm not as fast you. can you send me a link where as i can see how i can implement this :( thanks and...
  23. K

    Finding DOB

    Hi Hui, Thanks for the hand, infact i can't access my ex-----55@hotmail.com. i tried to reset the password but still could not make it. but yes, that is the first email i used to join chandoo. Yes i have some posts before and it is related to matching data by lookup different sheet, i think...
  24. K

    Finding DOB

    Hi Dave, Thanks for your quick reply. i tried to use your magic formula, some cell indicating no and some return to value. not sure, why u can't see the link as i have tried before posted into this forum. perhaps any suggestions. Thanks and regards, Keanur
  25. K

    Finding DOB

    Dear Excel ninjas, first of all, i just rejoined the community as i lost my previous password. here is i have table extracting from system and it contains No, Name and DOB and it is a big data as sometimes we extracted with a long date of range ( 1950 - 1995). i was trying to find specific...
Top