Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Trying to determine if employees are colluding to get overtime. In essence, One employee would take the day off, receive sick pay, and get a friend to cover their shift, resulting in the friend receiving overtime pay. Then they swap places, and the one employee would receive overtime, and the friend would receive the sick day pay off
Solved by G. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 28/03/2018 - 03:56
Excelchat Expert 28/03/2018 - 03:56
Hi there
User 28/03/2018 - 03:56
Hi
Excelchat Expert 28/03/2018 - 03:56
How are you and how may i assist you today?
User 28/03/2018 - 03:57
Trying to determine if employees are colluding to get overtime. In essence, One employee would take the day off, receive sick pay, and get a friend to cover their shift, resulting in the friend receiving overtime pay. Then they swap places, and the one employee would receive overtime, and the friend would receive the sick day pay off
Excelchat Expert 28/03/2018 - 03:57
Okay, i will try my best to help you out with this
Excelchat Expert 28/03/2018 - 03:58
Can you share me a sample worksheet
User 28/03/2018 - 03:58
I cannot as the information is confidential
Excelchat Expert 28/03/2018 - 03:58
So that we both can have a better evaluation to resolve the issue
Excelchat Expert 28/03/2018 - 03:58
Okay that will be good there
Excelchat Expert 28/03/2018 - 03:59
User 28/03/2018 - 03:59
its essential laid out like this
User 28/03/2018 - 03:59
but with a lot more data
Excelchat Expert 28/03/2018 - 03:59
okay
Excelchat Expert 28/03/2018 - 04:00
Can you show me an example of a resultant column
User 28/03/2018 - 04:01
I am sorry, what do you mean by resultant?
Excelchat Expert 28/03/2018 - 04:01
Like, how you want to treat these data
User 28/03/2018 - 04:01
so I would like to isolate instances where the employees would be alternating between being sick and receiving overtime
User 28/03/2018 - 04:02
The names repeat too, for example, abby might be sick 3/1 3/2 3/3 etc
Excelchat Expert 28/03/2018 - 04:03
request you to provide me a specific data so that i can create a logic for the formula
Excelchat Expert 28/03/2018 - 04:03
else that would be quite difficult for me to derive the formula
Excelchat Expert 28/03/2018 - 04:09
I know that you understand the requirement, but m totally unaware that how you want to get the calculation done for the requirement untill, i dont have the clear visibility on the raw data from where the formula is to be derived
Excelchat Expert 28/03/2018 - 04:09
Hope you get that
Excelchat Expert 28/03/2018 - 04:13
Are you there?

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.