Closed

Excel formulas for progressing excel sheet

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.

Skills: Excel, Excel Macros

See more: excel progress bar chart, excel conditional formatting data bars based on another cell, progress bar in excel, cumulative formula in excel, excel 2016 progress bar, in cell bar chart excel, how to create progress bar in excel 2007, excel conditional formatting percentage bar, microsoft excel formulas cheat sheet, excel formulas cheat sheet, excel formulas sheet expenses, excel estimated net seller sheet, vba excel lock columns refreshing sheet, excel automatic copy database sheet, accounting excel formulas pro forma

About the Employer:
( 0 reviews ) India

Project ID: #15230864

27 freelancers are bidding on average $11/hour for this job

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 More

$12 USD / hour
(192 Reviews)
7.1
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 More

$12 USD / hour
(31 Reviews)
5.1
zu02

Hi I hope all's well with you. I see you're looking for a developer proficient in Ms /Excel/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. Would you like to have it via Ms Access More

$12 USD / hour
(14 Reviews)
5.0
AhmedHassan1122

Excel VBA Developer with ample experience in macros development . I am available to do this job perfectly.

$12 USD / hour
(5 Reviews)
3.4
georgehongo1

Thank you for your project Proposal ID 15230864, referenced "Excel formulas for progressing excel sheet". This is a simple task which requires keenness and attention. It involved setting a spreadsheet and developing ap More

$15 USD / hour
(2 Reviews)
3.1
dongmei1993

I have many experiences for data processing and filling using advanced functions of the Excel including Excel VBA and Excel Macro. I always guarantee high quality and trust when working with my clients. We can unde More

$8 USD / hour
(2 Reviews)
2.6
mD4work

we can complete the excell file within 1hr for 8 $/hr Ready to start immediately pls do contact us.

$8 USD / hour
(1 Review)
2.2
shrirammeena

Experience Quality speed sharp and perfect Because always work in this field i have finished my work sharp time Give me a chance

$10 USD / hour
(0 Reviews)
0.0
raj13j

An Expert in Excel VBA, I have done similar programming for my client and made a tool out of excel. This work should be done in couple of days time

$12 USD / hour
(0 Reviews)
0.0
geraldlwm

A proposal has not yet been provided

$13 USD / hour
(0 Reviews)
0.0
$12 USD / hour
(0 Reviews)
0.0
waqasdastagir

Hi, I have a lot of experience working with Big data and complicated excel spreadsheet. I am level 7 advanced trained in excel VBA so I feel I should be able to meet the requirements of the project. I have a de More

$11 USD / hour
(0 Reviews)
0.0
Rubayat1

A proposal has not yet been provided

$8 USD / hour
(0 Reviews)
0.0
nidhib93

A proposal has not yet been provided

$11 USD / hour
(0 Reviews)
0.0
yasmineraslan83

A proposal has not yet been provided

$11 USD / hour
(0 Reviews)
0.0
filipninkovic

I worked on similar projects, I have experience. I'm sure we'll work together nicely.I hope you choose me, thank you.

$12 USD / hour
(0 Reviews)
0.0
xadan

I will provide you the best. Relevant Skills and Experience I have good knowledge about excel.

$12 USD / hour
(0 Reviews)
0.0
edisonandres

Good day. My name is Andrés Rivera. I am system engineer with 15 year expirience. I have worked with excel, excel macros. Do not hesitate to contact me by chat.

$11 USD / hour
(0 Reviews)
0.0
Vijayanand2071

Sir i complete this project

$11 USD / hour
(0 Reviews)
0.0
jenniffermontero

Soy Lic. en Negocios Internacionales, me he desempeñado como tecnico en los ultimos 4 años, soy proactiva, responsable, puntual y dispuesta siempre a dar la milla extra en lo que emprendo.

$11 USD / hour
(0 Reviews)
0.0