Quote:
|
Originally Posted by frankjh19701
I have data, numeric values, in mulitple columns and I need to find out how often values in one column occur with another value in another column. For example, if in column A there are values 176,2902,331... and in column B 3134,3415,6345 and so on, but I needed to find find how often 176 occured with 3415, how would I do that?
|
I forgot to mention, I need to maintain the numeric values in their respective rows. In other words, I need to find out how often the same two numbers occur within the same row (While being in diferent columns). I hope that clarifies things.