Return date if calendar equals "eg/ig"

[steve89]

hi trying to find a formula for my leave tracker which has a calendar and is as follows:

C11:AG11 = Days in the months by the number format
B12:B23 = months in the year: Example: "january"
C12:AG23 = infractions or paid time off we enter
but i want the formula to look for "EG/IG" and if so return the date that it occured

also would like a separate formula to sat if "EG/NI" was giving then text should equal "no" and if EG/IG" was giving text should say yes.
EG stands for evaluation giving
IG stands for increase giving
NI stands for no increase giving

thanks everyone hope to get some help

=IFERROR(IF(BK27<>0,IF(BK29>=BK29,"YES","NO")&TEXT(BK29/BK27,),"NO"),"YES")
this is what i have now if the formula see "EG/IG" it reads as yes but dont know how to incorporate "EG/NI" as no.

 

[steve89]

hey Joe been a long time hope all is well i had a question regarding an issue im having here is the data: the question i have is i have the formula setup as you can see showing if the shifts in "Employee Data" are missing then its tells me which one is missing. Issue i would like in a different cell is tell me if two duplicate shifts are listed in this example see cell D21 and D30 where the two employees are scheduled on the same position/shift. would love an alert to tell me when there are duplicates so we can remove them and not over schedule. Thank you so much

Excel Workbook
	D
20	OFF
21	AM 1
22	VAC
23	AM 4
24	AM 3
25	N/A
26	PM 1
27	AM 2
28	PM 3
29	OFF
30	AM 1
31	PM 4
32	PM 2
53
54
55
MASTER UNIVERSAL SCHEDULE

Excel Workbook
	A
2	AM COOK
3	PM COOK
4	PR COOK
5	AM 1
6	AM 2
7	AM 3
8	AM 4
9	PM 1
10	PM 2
11	PM 3
12	PM 4
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
Employee Data

 

[Joe4]

It is best to start a new thread instead of posting to one that has been dormant for over a year (especially since you got in over my head at the end).
You can always include a link back to this thread, if there is anything in there that is relevant that a person would need to know in order to answer your new question.