Excel Formula Development

Tamamlanmış İlan edilme: 1 ay önce Teslim sırasında ödenir
Tamamlanmış Teslim sırasında ödenir

I'm in need of someone highly proficient in Excel to create a specialized formula for a particular task. This includes:

- Creating a formula that can accurately detect if any of three specified texts are present within a cell, regardless of the order or placement.

- Upon detecting any instance of these specified texts, the formula should automatically enter '0' into the cell.

Ideally, you should have extensive experience with complex Excel operations. A deep understanding of text-related functions in Excel, including search functions and logical conditionals, is necessary for the successful completion of this project. Familiarity with large datasets and maintaining accuracy throughout could be helpful. Please ensure your bid reflects your understanding and capability of fulfilling these requirements.

Excel Veri Girişi Veri İşleme İstatistik Matematik

Proje NO: #37831974

Proje hakkında

91 teklif Uzak proje Aktif 1 ay önce

Seçilen:

(78 Değerlendirme)
6.4

Bu iş için 91 freelancer ortalamada £91 teklif veriyor

hdlan

Hi Joyce, I am a skilled Excel professional from Vietnam with 10+ years of experience. I can help you with formulas and calculations for your spreadsheet. I am available online most of the time and respond to messages Daha Fazla

£30 GBP in 2 gün içinde
(148 Değerlendirme)
9.6
schoudhary1553

With a solid seven-year stint as a Full-stack Developer, the past four of which I've spent focusing primarily on Excel, I can confidently say that your project is well within my realm of expertise. My forte lies in dev Daha Fazla

£180 GBP in 4 gün içinde
(608 Değerlendirme)
8.6
P0L

Hello, I am an Excel expert and I can write the function that you need. Please check my profile and contact me to discuss further details. Regards.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(515 Değerlendirme)
8.1
nagyzoltan68

Hello, I would like to work on your project. I have extensive experience using Excel macros / VBA, formulas.I can do this task with a formula or macro. In the case of formula, the cell will contain formula although it Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(191 Değerlendirme)
7.0
Giovanni704

Hi there! As I have read, I see you need help creating a specialized formula in Excel, and I could help you! I am highly proficient in Excel and have extensive experience with complex operations. Not to mention I have Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(63 Değerlendirme)
7.1
AnowarRatul

Hi, I can create a formula to detect specified texts in any order, automatically entering '0' in cells. Proficient in text functions and large datasets. Best,

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(423 Değerlendirme)
6.9
mairajali11

As an Electrical/Electronics Engineer, I have an intricate understanding of complex Excel operations that will enable me to handle your project with precision. With my expertise in Mathematics, I am capable of creating Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(73 Değerlendirme)
5.7
faisal9263

Dear client, I am proficient in Excel with extensive experience in complex operations. I propose a formula utilizing a combination of SEARCH, ISNUMBER, and IF functions to accurately detect specified texts within a cel Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(21 Değerlendirme)
5.4
GKEvans

Hello, I have done something similar before but in this instance i had to search for specific text and if it was in a cell anywhere I had to change that word to a red font colour. I did this by creating a function in V Daha Fazla

£75 GBP in 3 gün içinde
(4 Değerlendirme)
4.9
sareheshak

I checked the excel file and understand that you need to formula to detect of there is text in cells , if found text should be return to 0 I can automation this process completely I'm available to work on it right no Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(28 Değerlendirme)
4.7
ACCASpogmai

"""""""""""""""""""""""""""""""""""ADVANCE EXCEL EXPERT/FORMULA/SPREADSHEET TEMPLATE"""""""""""""""""""""""""""""""""""""""""" ""Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(31 Değerlendirme)
4.3
Zakwan555

Hi, I am an experienced certified Cost And Management Accountant and I have more than 7+ years' experience in professional domain. I have gone through your project with interest and it seems a perfect match with my ski Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(16 Değerlendirme)
4.4
tkmaina868

Hello there, I will help with project on Excel Formula Development.I have read the instructions carefully and I clearly understand what is required of the project. I have handled several assignments on this field and I Daha Fazla

£150 GBP in 3 gün içinde
(10 Değerlendirme)
4.0
mariadian74

Hi there, I hope you are doing well! I am Dian from Indonesia but right now I am living in Madrid, once I read your description, I sure can contribute and deal with this job because this is my field. I have experience Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(15 Değerlendirme)
3.9
zubairmbafinance

Hello I am Excel Expert with more than 5 years of experience in this field, I have Finace background which makes me Ideal for this job. Please contact so we can discuss more about it Thanks

£20 GBP in 2 gün içinde
(22 Değerlendirme)
4.0
janita24

Hi Joyce O., Good afternoon! My name is Jane a professional Statistician with skills including Data Entry, Excel, Mathematics, Statistics and Data Processing. I have over 5 years in tutoring data analysis and statist Daha Fazla

£150 GBP in 4 gün içinde
(8 Değerlendirme)
3.7
remisanonymous

Hi, I downloaded and reviewed your attached file, and I'm sure I can make formula or VBA macro to complete your task. I corrected formula in column "Sat", so now 0 is automatically entered. Also I can create formulas f Daha Fazla

£20 GBP in 7 gün içinde
(12 Değerlendirme)
3.9
kavitadhingra

"Hey there, I'm Kavita and I bring to the table a solid career span of 15 years immersed in various technologies like Power BI, SQL Server, VBA, Excel, MS Office and SSIS. As an expert encompassing data processing and Daha Fazla

£135 GBP in 3 gün içinde
(9 Değerlendirme)
3.2
osamaazzam66

Hi, I can help you with the project and I am ready to start now. Please award me the project so that I can start working on it immediately. I checked the excel file, and I can quickly create the IF formula for you, how Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(12 Değerlendirme)
3.4
WISELY

Hey there. My name is Wesley. I am an expert in Excel, with extensive knowledge in writing logical functions including the kind you described above. I am available now. Please contact me with additional details. Thank Daha Fazla

£50 GBP in 7 gün içinde
(6 Değerlendirme)
3.1