Suoritettu

Excel expert

wondering if you can help me pls? In excel column I need to count the number of “D” and “d”. How do I differentiate in formula the capital letters from lowercase in the count? I entered =countif(e$6:e$17,”D”). And the same formula to count the lowercase but with a “d” instead. What would cost be to answer this question?

Taidot: Excel

Tietoa asiakkaasta:
( 0 arvostelua ) Toronto, Canada

Projektin tunnus: #34052435

Myönnetty käyttäjälle:

MamukaB

Good Day I can help to you for this case immediately I have 15+ year experience of Excel, Excel VBA So, you can trust to me. Result will be excellent Best Regard

$10 CAD 1 päivässä
(28 Arvostelua)
4.3

18 freelanceria on tarjonnut keskimäärin $21 tähän työhön

(554 arvostelua)
8.2
(470 arvostelua)
7.7
MimiFL

Hi, this is the minimum allowed bid and hopefully i can help you in matter of minutes. If you are interested, please let me know and i will try to help immediately. I am available right now. I created a sample ready f Lisää

$10 CAD 1 päivässä
(692 arvostelua)
7.4
daniyal3214

Hello, I will be glad to assist you with that. I am an advance level Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Lisää

$20 CAD 1 päivässä
(171 arvostelua)
7.0
(193 arvostelua)
6.4
Muhammad6979

Dear sir/madam I am excel expert. I am expert Accountant, writer, researcher, and bookkeeper. I am ACCA (Chartered Accountant). I am expert in EXCEL, QB, XERO, MYOB, and WAVE. You can see my profile. I do have the ab Lisää

$30 CAD 7 päivässä
(100 arvostelua)
6.1
PERPETUAL0

I can answer for this question with very minimum price regards ILYAS

$15 CAD 1 päivässä
(130 arvostelua)
5.7
AAGGMM

Hello sir I am Ahmed, a GOOGLE certified data analytic with very good skills in spreadsheets [(Google sheets and Excel); including advanced formula, macros, power query and pivot tables], SQL and R-Programming languag Lisää

$20 CAD 1 päivässä
(40 arvostelua)
4.6
(19 arvostelua)
4.5
aldobraida98

Hi, hope you're doing well! My name is Aldo. I am an advanced actuarial student. I have great knowledge of working with: R, Python, SQL, VBA, Excel, finances and statistics. I always deliver high quality projects with Lisää

$20 CAD 1 päivässä
(17 arvostelua)
3.9
meraki201

Hi! I hope you're doing good This is Meraki from a professional data scientist with 7 years of experience. I have necessary academic skills which provides me with the necessary background to handle your project. I've c Lisää

$30 CAD 3 päivässä
(0 arvostelua)
0.0
tayyabasohail19

Hi there, How are you? I have gone through your project requirement and I am sure about that I am exactly confident to finish this project successfully. Sounds like a right fit? I do not doubt that I can add a tremen Lisää

$20 CAD 7 päivässä
(0 arvostelua)
0.0
socialexpert4

Hey, I can help you Excel. Please send file. I have 2 years of Excel. I'll start now I will 100% accurate right away. Waiting for your response Thanks!

$20 CAD 1 päivässä
(1 arvostelu)
0.0
OmSaravanan

hello this is Omsaravanan from india,Tamilnadu . i can finish within 24 hours and i have experienced typing 4 years

$20 CAD 2 päivässä
(0 arvostelua)
0.0
Isaiah2day

I got you

$10 CAD 1 päivässä
(0 arvostelua)
0.0
pandeyritika22

Please find formula below for Uppercase D =SUMPRODUCT(LEN(A2)-LEN(SUBSTITUTE(A2,CHAR(ROW(INDIRECT("68"))),""))) Please find formula below for lowercase d =SUMPRODUCT(LEN(A2)-LEN(SUBSTITUTE(A2,CHAR(ROW(INDIRECT("100" Lisää

$20 CAD 7 päivässä
(0 arvostelua)
0.0
thegeekestgeek

SUMPRODUCT(LEN(E6:E17)-LEN(SUBSTITUTE(E6:E17,"d",""))) is the answer. If you like it, you can assign me the project and ask something else similar as well.

$10 CAD 1 päivässä
(0 arvostelua)
0.0