Hi guys,
I am using the match formula in the attached file to establish the row in which the first activity takes place on a certain ID. The issue I have is that there are multiple activities that take place on an ID, some of which take place before the Lead ID was created.
Hoping that someone has a way to establish the row in which the first activity takes please post the Lead ID creation date using the match formula.
I have attached a sample of my data which will make the task more clear but please feel free to request more information or instruction.
FYI - rationale for using match formula is due to the size of the actual file, attached is just a sample.
Thanks,
Pitcher
I am using the match formula in the attached file to establish the row in which the first activity takes place on a certain ID. The issue I have is that there are multiple activities that take place on an ID, some of which take place before the Lead ID was created.
Hoping that someone has a way to establish the row in which the first activity takes please post the Lead ID creation date using the match formula.
I have attached a sample of my data which will make the task more clear but please feel free to request more information or instruction.
FYI - rationale for using match formula is due to the size of the actual file, attached is just a sample.
Thanks,
Pitcher