Hi,
I have created a list of trends in excel that now needs to be cross reference with each other to see how many times the trend occurs with another trend. I have assigned each trend a column and a number as seen in my excel file. I need to find out how many times that P1 and P2 occur in the same row as one another, and then I need to do this for all of the other relationships. I was suggested by a family member to use a pivot table, but I am not familiar with them so I am hoping that someone could verify with me if this is possible. If it is, could you please point me in the right direction on how to accomplish this? Thank you in advance for saving me from doing this manually!!!
Bookmarks