I have a set of data in excel where each row has (amongst other things) two values and I want is to generate a sorted list of all pairings.

Example data:

```
Val1  Val2
------------
A     B
B     A
C     A
B     C
A     B
C     A
etc..

```

Example output:

```
Val1  Val2  Count
------------------
A     B     2
B     A     1
B     C     1
C     A     2

```

Is there a way to do this without writing VBA code.

**Edit:** I should add that my dataset is growing and I would prefer a solution that would update automatically as new data is entered.