Create Excel simple formula or macro

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

I have an excel sheet with 2 columns, the token and the name. There are three types of tokens: the ones that start with 's', the ones that start with 'w', and the ones that start with a letter other than neither 's' or 'w'. I need 3 counters, one for each type of token, to display how many tokens of each type are left (haven't been asigned). By not used I mean that there is no data in the name column. Each counter should refresh each time a name is introduced to the cell next to the token. I can specify further in the chat if I didnt explain my self clearly. The excel is attached. The counters need to be always updated, and it is actioned when the name is written.

Algorithm Data Science Excel Excel Macros Visual Basic

Project ID: #19213303

About the project

16 proposals Remote project Active 5 years ago

Awarded to:

TechnoGuruu

Hi, As per requirements I will develop VBA macro for you which will calculate number of tokens for each type as per description of the project. Please share your Excel sheet. I have expertise in Excel, formulas, Exc More

$30 USD in 3 days
(86 Reviews)
6.0

16 freelancers are bidding on average $29 for this job

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More

$50 USD in 1 day
(364 Reviews)
8.0
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.

$30 USD in 1 day
(349 Reviews)
7.4
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.

$50 USD in 1 day
(116 Reviews)
6.4
nagyzoltan68

Hello, I would like to work on your project. I have great experience using excel macros / vba, data formatting and data manipulation in excel. I didn't discovered yet, which worksheet contains tokens and names in your More

$25 USD in 0 days
(127 Reviews)
6.5
lightingdavid

Hello. I have good skills in "Algorithm, Data Science, Excel, Excel Macros, Visual Basic". I have working for 7+ years in this field. I 'm very interest to your project. I have checked your project description care More

$50 USD in 1 day
(101 Reviews)
6.0
musthree

Hi, let me do it for you in around 1-2 hours. You won't need to click anything to get it refreshes based on the name column. When you assign a token to a name then it calculates automatically.

$30 USD in 0 days
(7 Reviews)
4.9
Mokshith30

Hi I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous projects for my vba experiance T More

$25 USD in 0 days
(38 Reviews)
4.5
racer1900

Need growing of your Business? I have to make sure that your business will be growing with your latest position, your Business target, income&outcome and then etc. In generally, For raising Business, we should plan S More

$25 USD in 1 day
(1 Review)
0.6
BingLN

I have a lot of free time. I have lots of experience on this task. I am very qualified for this job.

$13 USD in 1 day
(0 Reviews)
0.0
Aletllo91

Amplio uso de Excel avanzado. Cumplo con los requisitos establecidos para poder desarrollar el trabajo requerido

$40 USD in 3 days
(0 Reviews)
0.0
mnavinvw

Hi, This is purely formula based. There is no need of VBA or Marco. This can be completed in less than 1 hour

$25 USD in 1 day
(0 Reviews)
0.0
MamunMohammad

Sir , I will be your best choice due to my skill and tons-of-time to be spared to your job. You will find me skilled and professional. It will cost you less than other freelancer to be sure.

$25 USD in 1 day
(0 Reviews)
0.0
yohanravindu9

I can work quickly and I like join with you Relevant Skills and Experience I can data entry

$10 USD in 2 days
(0 Reviews)
0.0