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 = [url removed, login to view] 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.
13 freelancer bu iş için ortalamada 25$ teklif veriyor
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
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
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.
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