Tamamlanmış

Create an Excel Formula

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.

Beceriler: Veri İşleme, Excel, Microsoft Office, Visual Basic

Daha fazlasını görün: create excel formula, create excel letter template, create excel survey template, Create excel Template, create excel file template, create excel template csv file, create excel report template, create excel database will create letters word template, create excel form template quickbook import, create excel template import, create excel template import data, problem utf create excel, create excel pivot table net, create excel file visual, create excel database can posted forums

İşveren Hakkında:
( 0 değerlendirme ) United States

Proje NO: #15868012

Seçilen:

asadkhan3533

Can do it now if you want me to work on it Relevant Skills and Experience Data Processing, Excel, Microsoft Office, Visual Basic Proposed Milestones $20 USD - Data Processing, Excel, Microsoft Office, Visual Basic S Daha fazlası

1 gün içinde 20$ USD
(36 Değerlendirme)
5.0

9 freelancers are bidding on average $42 for this job

P0L

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.

1 gün içinde 30$ USD
(220 Değerlendirme)
6.8
elqueabandona

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 Experi Daha fazlası

1 gün içinde 30$ USD
(180 Değerlendirme)
6.7
1 gün içinde 25$ USD
(128 Değerlendirme)
6.3
1 gün içinde 166$ USD
(12 Değerlendirme)
4.5
1 gün içinde 25$ USD
(21 Değerlendirme)
4.4
in 3 gün içinde30$ USD
(22 Değerlendirme)
4.0
rizwanjpi

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

1 gün içinde 30$ USD
(1 Değerlendirme)
0.5
1 gün içinde 25$ USD
(0 Değerlendirme)
0.0