I have a table of data that is approx 110K lines. It contains multiple years worth of information. I am trying to extract some information from it but am struggling to find an easy way to do so. Here is what I have
The data contains a list of companies(Col T), a list of customers(Col M), Year(Col AA).
I am trying to determine an easy way to pick a Company (Col T) and determine How many new customers(col M) they have in a particular year(Col T). In other words a a customer that ordered in first ordered in 2021 would be new in 2021 not in 2022 or beyond.
I am also trying to determine when a customer was lost for a particular company. In other works when a customer purchased the year before but not in the year in question.
I can setup the pivot tables to show this information but for each company they can be hundreds if not thousands of customers to go through so doing this manually is a huge time commitment. Any suggestions?
The data contains a list of companies(Col T), a list of customers(Col M), Year(Col AA).
I am trying to determine an easy way to pick a Company (Col T) and determine How many new customers(col M) they have in a particular year(Col T). In other words a a customer that ordered in first ordered in 2021 would be new in 2021 not in 2022 or beyond.
I am also trying to determine when a customer was lost for a particular company. In other works when a customer purchased the year before but not in the year in question.
I can setup the pivot tables to show this information but for each company they can be hundreds if not thousands of customers to go through so doing this manually is a huge time commitment. Any suggestions?
