More frequently couple in columns

Regular Visitor

Hello, how can I do to obtain the couple of numbers that occur more frequently in two distinct  columns in a range of cells:

i.e., I have column A and column B with their numbers, I want to know which couple of numbers occur in rows more frequently, the second more frequently and so on. Thanks for attention and best regards.

1 Reply


Let's say the data are in A2:B101.

Create the following formula in C2, then fill down.




Sort the data on column C in descending order. Columns A and B will show the most frequently occurring combinations at the top.


See the attached sample workbook for a way of returning the unique combinations in descending order of frequency (Microsoft 365 and Office 2021 only).