I have a spreadsheet such as the following
A 1 4 F
A 1 4 F
A 2 4 G
A 2 4 G
A 2 4 H
B 3 5 M
B 3 5 M
B 1 4 F
and want to create a table that shows how many of each unique combination
are in my sheet.
Count
A 1 4 F 2
A 2 4 G 2
A 2 4 H 1
B 3 5 M 2
B 1 4 F 1
There are about 500 unique combinations, so I need to be able to generate
the list automatically, and there are other columns in between with data I
want to ignore.

Any suggestions?