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.

=SUMPRODUCT(--(A1:A100=176),--(B1:B100=3415))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"frankjh19701" wrote in message
...

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?




--
frankjh19701

Thank you. It works only on one row at a time. How can I get it to search across all of the rows for the presence of the values? The series runs from left to right across a row in multiple columns, so I need to find the couplings that could be not just in Column A & B, but possibly from A to C, or from C & F and so on.

Thank you. It works only on one row at a time. How can I get it to search across all of the rows for the presence of the values? The series runs from left to right across a row in multiple columns, so I need to find the couplings that could be not just in Column A & B, but possibly from A to C, or from C & F and so on.

Thank you. It works only on one row at a time. How can I get it to search across all of the rows for the presence of the values? The series runs from left to right across a row in multiple columns, so I need to find the couplings that could be not just in Column A & B, but possibly from A to C, or from C & F and so on.

It works across all the rows, not one at a time.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"frankjh19701" wrote in message
...

Bob Phillips Wrote:
=SUMPRODUCT(--(A1:A100=176),--(B1:B100=3415))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"frankjh19701" wrote in
message
...-

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?




--
frankjh19701 -
Thank you. It works only on one row at a time. How can I get it to
search across all of the rows for the presence of the values? The
series runs from left to right across a row in multiple columns, so I
need to find the couplings that could be not just in Column A & B, but
possibly from A to C, or from C & F and so on.




--
frankjh19701

Thank you again for your help, it does work across the entire row. I didn't realize that until I looked further. My next move is to analyze if there are more than two occurences repeating with another, i.e. if 176 & 3415 are in the same row, how often does 981 occur? And then, from there, how do I NOT count a row? Perhaps can I exclude it in the formula but include the other rows?

Also, I forgot to mention this earlier, the formula you presented only works if the value is in the first column. If it isn't I get a zero, when I know the value does occur in other rows. How can I get the formula to count across the entire row from every column, not just starting from the first one? SUMPRODUCT seems to be the key, but am I doing something wrong?