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.


Beceriler: Excel

Daha fazlasını gör: 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



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 Fazla

%selectedBids___i_period_sub_7% gün içinde 10%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(18 Değerlendirme)

12 freelancers are bidding on average $25 for this job


A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(249 Değerlendirme)

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(215 Değerlendirme)

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 Fazla

in %bids___i_period_sub_35% gün içinde22%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(174 Değerlendirme)

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 %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(69 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(34 Değerlendirme)

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 %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(21 Değerlendirme)

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 %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(45 Değerlendirme)

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 %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(9 Değerlendirme)

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 Fazla

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)

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 %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)

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 %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)