Google Spreadsheet Post #2360
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Feb-03-2018
question by shimoda
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/miPwUBHQTNg;context-place=forum/docs
How to find an employee last pay rise to calculate his next pay check using ARRAYFORMULA
How to find an employee last pay rise to calculate his next pay check using ARRAYFORMULA
I am looking for a way using ARRAYFORMULA to get an employee last pay rise to calculate his next pay check. The goal is to find the last pay rise effective before the beginning of the pay period. I want to use ARRAYFORMULA in order to avoid copying formulas down the sheet.
I have not found an example where ARRAYFORMULA allow to retrieve a value when searching for a text value (employee name) and the BEST matching date that would fit inside a time interval (so not an exact date match value).
https://docs.google.com/
I would be happy to read your suggestions.
No comments:
Post a Comment