Search results

Hi @AVK, Thanks for showing the way, I will use this formula

Hi @p45cal tried to plug in the formula, however always has the error notif. Any suggestion? thanks

Hi Excel Ninja, I would like to know, how to split monthly budget to daily budget with dynamics number. I include actual numbers from year 2022 as reference and also the worksheet as a sample. Thank you Keanur

Hi @pecoflyer another lesson to learn, thanks for this. I saw the formula is very simple yet powerful. Cheers

Hi Etaf, Thanks for enlighten myself, i was doing the opposite so that's why the formula did not work well (my reference was from the highest to the small criteria). To answer you: over then 11 means open to sell, and i have added this to my formula. The row if fix. Regards,

Hi All, Good day. I'm recently creating a simple report to show different price setup, in this case i use fruits as my subject. I have done several tests "If Formula" for the last 2 hours and still not find the right setting. Really appreciate if anyone can help me on this, also I would thank...

Hi Vletm, due to the sensitivity of the data, i cant share the original file. i hope you can understand.

Hi Pecoflyer, I actually want to ask that question, i need to understand the logic. Would you be able to breakdown the formula and explained, as you said it might be help me in the future. Thanking you in advance.

Hi Pecoflyer, thank you very much for the help..yes it is working now.

Hi Vletm I tried to use different type of excel but still not give me a proper result. do you mind to elaborate more?

Hi Excel Ninjas, I have a csv file and i converted it to excel, somehow the price column (E1) looks weird as i can't apply sum formula unlikely on column D. i have tried several ways: text to column, smart tag, paste special, value function, replace comma but none give a proper result. May i...

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

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

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

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

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

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

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

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

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

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

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

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

Thank you so much Narayan! cheers

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