Looking to create formula for a standard template that I use on a daily basis. We use this as a quick qualifying for potentially interesting companies sourced from larger lists, conference lists, etc. I've attached a version of the template with a sample set of data, which I categorized manually. Ideally I would like to be able to run a formula in Column A to categorize "Priority" as a 1, 2, or 3. The criteria for the Priority categorizations are as follows:
3- (must meet at least 1 datapoint)- ownership status = "public" or "public sub" OR greater than $100M in total funding OR greater than 1000 employees
2- (should be catch-all for whatever is not a 3 or 1)- ownership status NOT "public" or "public sub" AND total funding between $99M - $60M AND/OR Less than 30 employees
1- (must meet all datapoints)- ownership status NOT "public" or "public sub" AND less than $59M in total funding AND between 999-31 employees
If there are any question I'm happy to clarify in more detail.
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Stay tuned, I'm still working on this proposal.
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros.
Check my reviews.
Best regards
Relevant Skills and Experience
VBA/Formulas
Proposed Milestones
$30 USD - final delivery
Hello, I am ready to work and i need to ask some question.
Relevant Skills and Experience
I have done 600+ projects on excel at Upwork.
Proposed Milestones
$30 USD - One time is good