Completed

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?

Skills: Excel

About the Client:
( 0 reviews ) Toronto, Canada

Project ID: #34052435

Awarded to:

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 in 1 day
(28 Reviews)
4.3

18 freelancers are bidding on average $21 for this job

(554 Reviews)
8.2
(470 Reviews)
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 More

$10 CAD in 1 day
(692 Reviews)
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 More

$20 CAD in 1 day
(171 Reviews)
7.0
(193 Reviews)
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 More

$30 CAD in 7 days
(100 Reviews)
6.1
PERPETUAL0

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

$15 CAD in 1 day
(130 Reviews)
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 More

$20 CAD in 1 day
(40 Reviews)
4.6
(19 Reviews)
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 More

$20 CAD in 1 day
(17 Reviews)
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 More

$30 CAD in 3 days
(0 Reviews)
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 More

$20 CAD in 7 days
(0 Reviews)
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 in 1 day
(1 Review)
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 in 2 days
(0 Reviews)
0.0
Isaiah2day

I got you

$10 CAD in 1 day
(0 Reviews)
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" More

$20 CAD in 7 days
(0 Reviews)
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 in 1 day
(0 Reviews)
0.0