Excel formulas for progressing excel sheet

Stängt Publicerat 6 år sedan Betalades vid leverans
Stängt

We have an excel file that keeps track of staff attendance and languages.

Each day an X is placed next to the name of the person who is working that day.

2. On the bottom of that column for that day, we need to add totals of:

a) How many sales staff total were there

b) How many sales staff per language was available

Lastly we need to clean up the sheets.

See SEPTEMBER 2017 for an example of how the column should look.

To do this we added another sheet at the end, called 'DATASOURCE'. That has all the info about which staff member speaks which languages.

I need this asap.

Attached the excel sheet to work on.

Excel Excel Macros

Projekt-id: #15230925

About the project

22 offerter Distansprojekt Aktivt 6 år sedan

22 frilansare har lagt bud på i genomsnitt $11/timme för det här jobbet

schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Mer

$12 USD / timme
(187 omdömen)
7.0
TonmoyRoy111

A proposal has not yet been provided

$10 USD / timme
(199 omdömen)
6.2
abhinovpankaj

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat Mer

$12 USD / timme
(30 omdömen)
4.9
humayoonsheikh4u

Dear Sir I am an excel professional having hands on expertise in developing spreadsheet for analytical purpose I will do your project as per your requirements by applying advanced excel formulas. Relevant Skills and E Mer

$8 USD / timme
(8 omdömen)
4.0
suyashdhoot

Hi I am a very experienced statistician and data analyst. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done Mer

$25 USD / timme
(4 omdömen)
3.9
rameshmahala

Hello there, I would like to be considered for this job as I have good knowledge of Excel formulas and vb macros. Thanks, Ramesh

$8 USD / timme
(3 omdömen)
2.6
sadaqatali408

hi thanks for the opportunity i have read out all the information related to your staff attendance and i can use all the formulas there. why you dont knock me here now for further details . you can pay me after checki Mer

$12 USD / timme
(8 omdömen)
2.3
martInghia

I am Industrial Engineer graduated in 2005 with a certification as Project Manager Professional in September 2015. I have been working during the last 12+ years in industrial management in leading companies of Argenti Mer

$12 USD / timme
(1 omdöme)
1.9
nelumindralal

Hi, there is no attachment to prefer I went through the description, and this can be done within 1-2 days. I am Mechanical Engineer and frequently I solve this kind of excel tasks by automating with Macro and VBA Mer

$8 USD / timme
(1 omdöme)
0.2
EWORX

Please Allow Me To Assist You For Best. I am Expert In It. I Can Certainly Do Your Work According To Your Requirement With In Short Time. I Have More Then 9 Years Of Experience In Multiple Areas Of Computer Science and Mer

$12 USD / timme
(0 omdömen)
0.0
nbprince

Hi, dear employer, I read your project carefully. Yes I will create formulas for your this excel project for the persons. We can decide the exact budget when you will get back to me in inbox with exact requirements. Mer

$8 USD / timme
(0 omdömen)
0.0
tcruzvany

I have 7+ years using Microsoft Excel. One of my jobs actually had me doing something very similar to the task at hand.

$11 USD / timme
(0 omdömen)
0.0
tuanthanhle

A proposal has not yet been provided

$10 USD / timme
(0 omdömen)
0.0
rrodriguez1407

A proposal has not yet been provided

$16 USD / timme
(0 omdömen)
0.0
arinappsol

I have familiar experience in Excel and worked on this type work daily basis on my office as it needs. I can work on this project and help you to finish this project. Thanks, Arindam.

$8 USD / timme
(0 omdömen)
0.0
Mubarekha

A proposal has not yet been provided

$16 USD / timme
(0 omdömen)
0.0
ksalam7

Hi, I'm interested to work on your project. I've done a similar Excel worksheet for my current employer with Macros which can calculate Employee overtime for a month and generate reports like a calendar. I can use my Mer

$8 USD / timme
(0 omdömen)
0.0
sabilabry

A proposal has not yet been provided

$11 USD / timme
(0 omdömen)
0.0
varunprakash23

I have immense knowledge in Excel macros and formulas with over 10 yrs experience. Kindly award me this project to prove myself as I am new to freelancer.

$11 USD / timme
(0 omdömen)
0.0