excel formula(google spreadsheet)

I need couple excel formulas which will work on google spreadsheets:

first formula

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.

second formula

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

Beceriler: Excel

Daha fazlasını gör: using google spreadsheet, google lookup spreadsheet, formula it, golf handicap formula excel spreadsheet, google calendar excel spreadsheet, mortgage capital repayment formula excel spreadsheet, put excel spreadsheet google docs, link excel spreadsheet google maps, add google finance excel spreadsheet, lowest bid formula excel, formula excel, advertising formula excel, interest payment formula excel

İşveren Hakkında:
( 1 değerlendirme ) Muscat, Oman

Proje NO: #8606089



hello sir, i am ready to strat work pease give me work i am expert in this work best regards thanks

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(1 Yorum)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(153 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(6 Değerlendirme)

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,

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)