Forum Discussion
More frequently couple in columns
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 whi...
Let's say the data are in A2:B101.
Create the following formula in C2, then fill down.
=COUNTIFS(A$2:A$101,A2,B$2:B$101,B2)
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).
FYI : This solution also works in 2016.
This solution is exactly what I was looking for. Thank you.
