registration analysis

[#1]

Hi guys,

Hoping you can help me I have 3 excel files each with a registration e-mail , and sets of parameters for being active for that particular wave.

So i wanted to end up with stats for the following  I tried using count of email address for each wave but wasn't working

Active participants this wave

Participants which are active for this wave but not for the last

Participlants which where active for the last wave but not this one.

Thanks  !

Sarah

[sujeetsingh]

Sarah,

You need to come in details with all fields and then explain .

Seems your script require a conditional statement to derive these things.

[#3]

Hi Sujeet

Thanks for your help im  using the fields

Email, leasing company (for leasing companies =vLeaseCo), and activity. Have a separate spreadsheet for each wave so Im loading the same data from each with outer joins

Thanks

Sarah