Đang Thực Hiện

I would like to hire an Excel Expert

I am making a schedule on excel and I using =IFERROR(VLOOKUP(M3,Friday, 8,FALSE),0)+IFERROR(VLOOKUP(M3,Saturday, 7,FALSE),0)+IFERROR(VLOOKUP(M3,Sunday, 6,FALSE),0)+IFERROR(VLOOKUP(M3,Monday, 5,FALSE),0)+IFERROR(VLOOKUP(M3,Tuesday, 4,FALSE),0)+IFERROR(VLOOKUP(M3,Wednesday, 3,FALSE),0)+IFERROR(VLOOKUP(M3,Thursday, 2,FALSE),0)+P3

To count peoples name and report back how many times it finds them on a friday-thursday schedule. It counts the name and times it by a specific hours for which that position is slotted for.

The problem is that it only counts the name once in a column. For example

Monday

John is working slot A 1400-1800 HRS (SHEET1 CELL G4)

and John is also working Slot C 1800-2200 (Sheet1 Cell G7)

It only counts slot A and ignores slot C

I need it to count both.

Kỹ năng: Nhập liệu, Excel, Phát triển phần mềm

Xem thêm: excel experts for hire, excel experts online help, excel expert pdf, excel expert online chat, excel freelancers, excel experts forum, excel expert salary, excel programmers for hire, Create and EXCEL file like the original PDF, Hello. I would like you to make two logos for a company. Please open the attached document to view the logo instructions., need excel expert on hire, ms excel expert for hire, microsoft excel expert for hire in atlanta ga, how can i install hire gps on the car, how bid the project and massage hire manager i freelancing com

Về Bên Thuê:
( 1 nhận xét ) Bell, United States

Mã Dự Án: #14831043

Đã trao cho:

imransgd101

Hi, I am Imran from Pakistan, I am ready to start right now and try to complete as soon as possible. I have great skills for related to Job, you can check my profile for my client review etc for your complete satis Thêm

$16 USD trong 0 ngày
(192 Đánh Giá)
6.6

17 freelancer đang chào giá trung bình $21 cho công việc này

cgullapalli

Hi, I am good at Excel and vba. I just checked the description and would be a pleasure to assist you on your project. Looking forward to discuss in the chat. -Chandra Relevant Skills and Experience excel vba, for Thêm

$10 USD trong 0 ngày
(503 Đánh Giá)
7.5
P0L

Hello, I’m an Excel expert and I would like to help you with your formulas. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm still working on this proposal.

$25 USD trong 1 ngày
(176 Đánh Giá)
6.6
ReliableMate

Will do this one for a good review! Professional work, in time, with ZERO errors, for sure! We can do this for you quickly and with great quality as per your budget.. We aim to be your one stop solution for ALL Thêm

$20 USD trong 0 ngày
(54 Đánh Giá)
6.1
$20 USD trong 1 ngày
(16 Đánh Giá)
3.9
saadrashad

vlookup only return 1st reference of search match result. share the file and let me see what are possibilities of it may be group by need to be used Relevant Skills and Experience 16 years experience 232 projects on Thêm

$25 USD trong 0 ngày
(13 Đánh Giá)
3.8
maxvil32

A proposal has not yet been provided

$30 USD trong 1 ngày
(45 Đánh Giá)
4.1
awaisjahangir25

I can work on it sir, I am good in using advance formulas. do let me know over chat. Relevant Skills and Experience MS Excel Proposed Milestones $30 USD - Upon Completion

$30 USD trong 1 ngày
(11 Đánh Giá)
4.1
dvcontact

Hi, If you are looking for a professional and reliable Excel expert with proficiency in data analysis, I'm your ideal candidate. I'm highly experienced in producing mathematical solutions with Excel and I have a stron Thêm

$25 USD trong 1 ngày
(6 Đánh Giá)
3.6
$25 USD trong 1 ngày
(1 Đánh Giá)
0.8
SidhuDN

I wait for your reply. Please reply me then we discuss more details of this project. Hope you response me soon. Relevant Skills and Experience Data Entry, Excel, Software Development Proposed Milestones $25 USD - Gu Thêm

$25 USD trong 1 ngày
(0 Đánh Giá)
0.0
patryksobczak

That is a simple and straightforward task. Preferred Teamviewer / Skype contact. I can explain you, why using VLOOKUP is bad idea. Relevant Skills and Experience I have been an expert on Excel and Visual Basic for thr Thêm

$20 USD trong 0 ngày
(0 Đánh Giá)
0.0
Mamdouhdalia

I have experience in that field according to my previous work as teacher at multinational school where i taught using Microsoft Office. Relevant Skills and Experience ICDL Proposed Milestones $25 USD - Excel

$25 USD trong 1 ngày
(1 Đánh Giá)
0.0
noka1

Hello. Since you need to count more than one entry most likely you need to use COUNTIF / SUMIF formulas. I can help. Thanks. Relevant Skills and Experience I am an experienced Excel developer with over 14 years of exp Thêm

$20 USD trong 1 ngày
(0 Đánh Giá)
0.0
SureshXobos

Hi there. I saw your project on the count formula. It can be done in quick time .VLOOKUP stops once it gets the value it is told to. Modify it. Relevant Skills and Experience Being an intern at an audit firm, I wor Thêm

$10 USD trong 1 ngày
(0 Đánh Giá)
0.0
Ruhithasan94

# I am expert in Typing, Web Research, Virtual Assistant, work.I would like to express my interest to your post and i think i can do Any Type Of Data work.# &&&&& I new in [url removed, login to view] i have enough experience Thêm

$12 USD trong 1 ngày
(0 Đánh Giá)
0.0
jasonclement0

A proposal has not yet been provided

$15 USD trong 1 ngày
(0 Đánh Giá)
0.0