Identify parent record using IF function to combine the scenarios

Hi,

Actually, the data is identified separately of different combinations of backup senarios from Column H onwards. In Column A is just the result I need to have as a forumala. This raw data is combined with different senarios which has 30,000 over records.

For a better understanding, I have attached another file. Is it a good idea to separate the scenarios in different files mannualy from the 30,000++ records. Really need your advise. Thank you.

Hi,

Please find PFA with rectify your problem.

Regards Imran.

This is not the result I need. The record with red ones are the parent Job. I just need to identify the parent job. I am just picking up the different scenarios and explained in the DataExplanation worksheet to inform that those are the parent job to be identified.

I just need to combine all the senarios in one formula. The reason is the use will be receiving the raw data of all the senarios combined of 30,000++ records which will be sorted.

Almost a month, I am finding a solution to this. Or let me know if there is a better idea.

Once I receive the raw data, I need to sort it by Policy Name, Job Start Date, Client Name. I shall identify by Schedule Name and Job Type.

The System will schedule the 1st Job which is the Parent. The 2nd jobs onwards are the Child backup which breaks into smaller jobs. (I don't need to know the Child jobs. It doesn't matter if the formula show as "False")

All Jobs as Same Client Name and policy Name except for No. 5 (VM Backup - with DB) has different Client Name.

I will receive a raw data of 30,000+++ with different secenarios with 1 heading only. I will sort by policy name and job Those different scenarios are picked and explained in the "DataExplanation" worksheet as a sample only which I need to identify the parent job only

I have already built using the if function where it differentiates by Schedule Name and Job Type. I just need to combine all the if functions into one formula to differentiate all scenarios when I extract all the 30,000 records.

I have reattached the file in the first thread.