Excel formulas for progressing excel sheet

終了済み 投稿 6年前 着払い
終了済み

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 Macros

プロジェクトID: #15230925

プロジェクトについて

22個の提案 リモートプロジェクト アクティブ 6年前

22 人のフリーランサーが、平均$11/時間で、この仕事に入札しています。

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 もっと

$12 USD / 時間
(187件のレビュー)
7.0
TonmoyRoy111

A proposal has not yet been provided

$10 USD / 時間
(199件のレビュー)
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 もっと

$12 USD / 時間
(30件のレビュー)
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 もっと

$8 USD / 時間
(8件のレビュー)
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 もっと

$25 USD / 時間
(4件のレビュー)
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 / 時間
(3件のレビュー)
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 もっと

$12 USD / 時間
(8件のレビュー)
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 もっと

$12 USD / 時間
(レビュー1件)
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 もっと

$8 USD / 時間
(レビュー1件)
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 もっと

$12 USD / 時間
(0件のレビュー)
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. もっと

$8 USD / 時間
(0件のレビュー)
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 / 時間
(0件のレビュー)
0.0
tuanthanhle

A proposal has not yet been provided

$10 USD / 時間
(0件のレビュー)
0.0
rrodriguez1407

A proposal has not yet been provided

$16 USD / 時間
(0件のレビュー)
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 / 時間
(0件のレビュー)
0.0
Mubarekha

A proposal has not yet been provided

$16 USD / 時間
(0件のレビュー)
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 もっと

$8 USD / 時間
(0件のレビュー)
0.0
sabilabry

A proposal has not yet been provided

$11 USD / 時間
(0件のレビュー)
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 / 時間
(0件のレビュー)
0.0