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: create excel formula, hire a freelancer to create excel heat maps, which of the following error values means that excel doesn t recognize your formula because there is either a misspelled functio, excel formula find instance column, excel formula instance column, 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, excel formula create digit luhn number, excel formula compound percentage column, create excel macro run powershell script, create excel form template quickbook import, create excel template import, create excel template import data, problem utf create excel, microsoft excel formula sheet, excel formula sheet, create excel pivot table net, create excel file visual, excel vba macro paste adjacent column, call web service excel formula

İşveren Hakkında:
( 1 değerlendirme ) New York, 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 Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(38 Değerlendirme)
5.1

Bu iş için 8 freelancer ortalamada $45 teklif veriyor

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 %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(234 Değerlendirme)
6.9
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 Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(186 Değerlendirme)
6.7
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(132 Değerlendirme)
6.4
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(18 Değerlendirme)
5.0
in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(26 Değerlendirme)
4.3
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 %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
0.6
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0