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.
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 Excel Ninja,
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...
Dear Excel Ninjas,
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 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?
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...
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...