extracted data from a table and grouped them into pairs would like to know how often they

Hi

I extracted data from the table using the concatenate function and got the front pair of numbers from the table

I created a table called front pairs.

I would like to populate the table with the number of times the pairs appears

I tried the countif function but lost along the way

I include my spreadsheet

Thank you in anticipation for any help or advice

The data from d6 to f6 is used and the front pair is copied to h6 on the spreadsheet

I created a table from o1 to x21

the table should contain the the total of times each pair appears from column h


raj

Hi

Thank you for the help

Much appreciated

Raj

Hi

Thank you so much

Much appreciated

Working brilliantly

Am learning agreat deal here in this forum