I'm trying to make a formula, which will return 'Moving' or 'Not moving' dependent on another value.
So, if item has 'NO' demand, and it's activity is below the six month period based on a specific date (01.04.2018) it will be called a 'Not moving' item.
If item has no demand, but was transacted in the 6 month period it will be called 'Fast moving'.
If an item has a demand, it will be called a 'Fast moving' item regardless of the date.
Activity Demand Item Type
01/10/2017 NO Apple Slow moving
01/10/2018 NO Banana Slow moving
01/10/2017 10 Apple Fast moving
01/10/2018 50 Banana Fast moving
Hello,
Hope you are doing well.
I can help with you in your project Excel expert. I can assure you the quality job.
I have good experience in Excel. We have worked on several similar projects before!
We have worked on 400+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion.
I can assure the 100% job satisfaction.
Thanks,
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work.
Completed more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction.
I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
Hi there,
I am an Excel expert with over 17 years of experience creating advanced formulas and functions. I'd love the opportunity to model out the formula that is required to automate the "Moving" or "Not Moving" results based on all of your specific criteria you have listed.
The 6 month period date could also be a variable so you would be able to adjust it if need be and the formulas would dynamically update.
Hopefully we can work together! I could do this for you today for sure.
Thanks either way,
Shaun
Hello there, as an expert in excel and VBA, i can help you to accurately such a formula in excel as you have specified. Please contact me and let us talk more about your project. Thanks
Hello,
I am Luis from Venezuela and it will be my pleasure to help you with this project.
I have experience with Excel and Visual Basic and I can do this for you.
Please contact me by chat and then we could discuss better your project!
Kind regards,
Luis Romero
Can you please share with me the same excel sheet with dummy data. The desired output can be achieved by nested "If statement" .
'Moving' or 'Not moving' will be calculated based upon the criteria mention in bid details. Please message me so that i could discuss with you , will provide solution fast.
Hello. I understand the requirements of this project and I am interested to work on it.
I am a reliable freelancer, focused on quality and completing projects in time.
Good knowledge of Excel.
Kindly consider my proposal.
Thank you.
Hello,
I can build this formula for you really fast as i have advanced excel skills and over 8 years experience. Please check my portfolio to see my work.
Thanks!
"Hello Dear,
Yes, I can work for you as per your project description With amazing exploration and experimental research abilities of mine is perfect for this project that you may require. My work fulfills as well as keep you returning consistently. It is because of the importance behind this field that I am confident & serious when taking these types of projects. Let me introduce with professionalism and skill that exists to supply the best. Regards"
I will be able to make the "Moving' or "Not Moving" based on the criteria You have mentioned.
I have 15 yrs Experience in Excel Macro, VBA, Word & Office Automation.
Please visit my tech blog officetricks to know more about my expertise or client reviews in here. I work full time in here & will be able to start your work immediately.
Services Provided:
1. Excel Macro (VBA)
2. Manual to Automatic updates in Excel
3. Excel Pivot Charts & Tables
4. Excel Auto Filter, Vlookup, Formula Assistance
5. Excel to Access
6. User Forms in Excel
7. Calendars in Excel
8. Bulk Files Processing in side a Folder
9. Folder Operations
10. Sending Email from Excel
11. Extract Data from Webpages
Please drop a message once you feel comfortable with my profile & lets get started with a feasible amount.
Thanks for your time
Dear Sir / Madam,
As an advanced excel user with valuable Financial / Analytical and Data Entry experience, I would be grateful if you would review my profile for the position advertised. Having worked at high levels within Finance, delivering accurate and timely reports to meet key deadlines has always been an essential part of the quality service I can offer. Also have vast experience in developing financial models via Excel (both basic and advanced).