I need couple excel formulas which will work on google spreadsheets:
I have 2 sheets one for data entry and 2nd to show the data entry in organised way (like a report). sheet1 contain repeated names and value for each name unique or repeated .. so in sheet2 the formula will lookup for the last entry for a specific name in column A copy value of column B in that row.
it is like an alert using time stamps. basically when someone put an entry a time stamp will appear next to it. again sheet1 will have name and timestamp, sheet 2 will look for the last entry of a specific name and then go to the cell where the time stamp is and calculate if the time now- time stamp=< 8 hrs then cell in sheet2 text will turn RED and backround will turn red also.
I hope that's understandable
hello sir, i am ready to strat work pease give me work i am expert in this work best regards thanks
Bu iş için 7 freelancer ortalamada $27 teklif veriyor
HI, I am available to start now.. I can complete both formulas in an hour. First formula can be done using array formulas. The second formula will require the use of Google Scripting to auto add the time stamp. Daha Fazla
Hi, i have full-time availability to work on your google spreadsheet and i can start right away! Im a skilled excel user with knowledge of VBA programming if needed. I can sure help you out in no time. I´ve built au Daha Fazla
Good day, First of all thank you very much for this job post. I'm very much interested on the job and would be very happy to work on this task. Thanks and best regards,
Sir/Madam, Good day! I'm a degree holder and I'm an expert in excel with more than 8 years experienced. I'm also a virtual assistant for 3 years doing excel jobs. You will find me motivated and hardworking. You may Daha Fazla
I read the description project. I've being working with excel since 2011. If you want to talk I'd like to receive a sample, I could understand almost what you want. We can discuss the details on chat. Regards, Ale Daha Fazla