Dear Readers,
I got a scenario last week like in our shop we have 1000+ jobs which runs everyday. We have got the entire list of jobs that runs in our server and the requirement is to differentiate Daily/Weekly/Monthly jobs in different colums. The only identity is the 4th character of the job name gives either it's weekly / monthly / daily.
4th character = D is daily W is weekly M is monthly.
So if it's daily i need to put Y it in column "Daily" , Weekly in Column "Weekly" , Monthly in Column "Monthly" (See below)
Job Name Daily Weekly Monthly
ABCD120N Y N N
BCED125N Y N N
ERED124N Y N N
WERW130N N Y N
TERM140N N N Y
The formula that i used is =IF(MID(A2,4,1)="d","Y","N"). It's nothing but i am taking the 4th character of the job name and if it's "D" then i place Y in that column else N. Same in monthly just replace "D" with "W" and for monthly "D" with "M".
No comments:
Post a Comment