Devam Ediyor

Excel Expert needed to add Data Validation & formulas

Budget $10

MS Excel (.xlsx). Should apply to whole column in sheet. Attached is sample file to use.

6 Simple Steps:

1. Add Data Validation to worksheet so if value added to sheet 1 column A exists in sheet 4 column A as duplicate show, show error alert as soon as user has entered value into sheet 1 column A.

2. Need to capture statistics based on below and have it update when new data added/removed.

A.) Number of values in sheet 1 column D and E excluding top row (if value exists in both columns on same row count as once only) and add total to sheet 3 D2

B.) Number of values in sheet 1 column T excluding top row and add total to sheet 3 F2

C.) Take value in sheet 3 C2 and convert in column sheet 3 and hidden column H2 from hours and minutes into hours. User will enter format as hours:minutes where minutes is to 60. Example user enters 03:50 this = 3.83 hours

D.) For sheet 1, take value in D2 and divide by value in H2 and result in E2

E.) For sheet 1, take value in F2 and divide by value in H2 and result in G2

Please reply back if you can do all of the above 6 steps so I can award to you.

Thanks

Beceriler: Excel

Daha fazlasını görün: file excel expert, excel formulas expert, data enters, excel sheet expert, need a excel expert, f2, excel expert, excel duplicate, excel 50/60, data validation, please worksheet attached, excel count, validation file, excel column update, add alert excel, excel sample file, sample excel worksheet, statistics data entered, file validation, can excel capture data, data analysis excel expert needed, excel sheet budget, excel duplicate values, excel simple steps, excel simple expert simple

İşveren Hakkında:
( 59 değerlendirme ) Enmore, Australia

Proje NO: #6528458

Seçilen:

MKL7

Dear, I have just completed the 6 steps as per your requirements, for myself, just for fun. I would be pleased to hand it over to you if you hire me. I am going offline now but will be back in 6 hours, ready to d Daha fazlası

0 gün içinde 10$ AUD
(1 Değerlendirme)
0.0

13 freelancer bu iş için ortalamada 25$ teklif veriyor

zExcel

A proposal has not yet been provided

1 gün içinde 60$ AUD
(106 Değerlendirme)
6.4
sawangupta

Hi, I can help you with your requirement. I have closed more than 150 excel projects at various forums. Please provide more details to help you better. Regards Sawan

1 gün içinde 15$ AUD
(18 Değerlendirme)
5.0
sajidmahmud

Dear Sir, I am extremely interested to your project and ready to start immediately. Sir if you give me chance I can do this job. I see your project and i do it as your acceptation. I have 3 years experience to wor Daha fazlası

1 gün içinde 25$ AUD
(67 Değerlendirme)
4.4
tomislav1975

Hello, I can do this. Pls check my portfolio and contact me if interested. Thanks, Tom_________________________________________________

1 gün içinde 40$ AUD
(12 Değerlendirme)
4.2
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work every day to excel. I have much experience with spreadsheets, formulas and macros. I am also an orderly, neat, methodical and committed person with my wo Daha fazlası

in 3 gün içinde22$ AUD
(16 Değerlendirme)
4.2
k00lcaptchrz

Hi. i have lot's of experience in excel. I can do this task for You ... Ready to start right now and can finish it quickly . Looking forward to hear from You soon. thank You Regards kool

1 gün içinde 10$ AUD
(27 Değerlendirme)
4.1
kher78

Hello, I could do this for you and provide you a draft within 24 hours for you to look at. I look forward to lending a hand!

1 gün içinde 30$ AUD
(11 Değerlendirme)
3.5
hemsingh1

Hi, Excel , VBA and data entry expert. Can work and complete the task as specified. Understood the requirement. Ready to Start. Thanks

1 gün içinde 25$ AUD
(4 Değerlendirme)
2.5
P0L

A proposal has not yet been provided

1 gün içinde 10$ AUD
(3 Değerlendirme)
2.1
rashidaliansari

Hello Sir I am Rashid Ali Ansari. We are a Mini Company in Pakistan and we are Providing all kinds of Internet services have altos of skills loaded and we can handle alots of work at a time we have Graphic Designer,Web Daha fazlası

in 0 gün içinde30$ AUD
(3 Değerlendirme)
1.7
MMuhammad1109

i have more than 5year experiance of Excel plz consider me for this job i'll charge only 10$ for this job.

1 gün içinde 25$ AUD
(0 Değerlendirme)
0.0
cgpetschel

It will require VB coding to take place, the minute a cell is changed it runs through the code regarding the active cell and will send a alarm or notification if it is incorrect.

1 gün içinde 25$ AUD
(0 Değerlendirme)
0.0
AlexandrK1

Предложение еще не подано

in 3 gün içinde30$ AUD
(0 Değerlendirme)
0.0
stanford4god

UK based English speaker. Already completed first task, require clarification for rest of task, but nothing a quick email exchange won't sort out. Rob Groves

1 gün içinde 20$ AUD
(0 Değerlendirme)
0.0