Hi there
So, I have the following situation on my hands (link to image)
I have 2 sheets, one for registered IDs and one for transactions IDs. Both IDs are unique customers identifications. Example: John registered on the platform and was given the 890 ID. If john makes a transaction, that transaction ID will be 890.
The sheet for Registered IDs provides me a few informations about the register: when it occurred, how (facebook, affiliates, etc), where (Market 1, 2 or 3) and also which type it is (Business or Individuals). The transactions sheet just gives me the IDs, when and the amount of each transaction.
I put those two sheets together so you guys can compare the IDs columns. As you can see, not all registered members makes transactions and there are several ones who makes more than one transaction. My challenge is to compare those 2 columns in a dynamic way so I can see and filter who is actually registering AND using the services. In other words, I have to see which REGISTERED IDs are appearing on TRANSACTION IDs.
So, I started whith conditional formatting to highlight the duplicates between the 2 and then filter by color, but the sheet have more than 70.000 rows and my computer nearly explodes when I try to apply the color cell filter. So I used VLOOKUP and made it work by classifying which values appears and those who doesn't. It worked, but every time I have to play with different variables (lets say market or channel), It's a pain in the * because takes so long to separate the IDs and filter them on a specific table.
So my question is: is there a way to make a Pivot table so I can filter the data more easily?
Thank you guys so much!
So, I have the following situation on my hands (link to image)
I have 2 sheets, one for registered IDs and one for transactions IDs. Both IDs are unique customers identifications. Example: John registered on the platform and was given the 890 ID. If john makes a transaction, that transaction ID will be 890.
The sheet for Registered IDs provides me a few informations about the register: when it occurred, how (facebook, affiliates, etc), where (Market 1, 2 or 3) and also which type it is (Business or Individuals). The transactions sheet just gives me the IDs, when and the amount of each transaction.
I put those two sheets together so you guys can compare the IDs columns. As you can see, not all registered members makes transactions and there are several ones who makes more than one transaction. My challenge is to compare those 2 columns in a dynamic way so I can see and filter who is actually registering AND using the services. In other words, I have to see which REGISTERED IDs are appearing on TRANSACTION IDs.
So, I started whith conditional formatting to highlight the duplicates between the 2 and then filter by color, but the sheet have more than 70.000 rows and my computer nearly explodes when I try to apply the color cell filter. So I used VLOOKUP and made it work by classifying which values appears and those who doesn't. It worked, but every time I have to play with different variables (lets say market or channel), It's a pain in the * because takes so long to separate the IDs and filter them on a specific table.
So my question is: is there a way to make a Pivot table so I can filter the data more easily?
Thank you guys so much!
