Hi, this is my first post, so i hope i have posted in the correct place.

I have been using excel for a while now but only for simple spreadsheet applications.

I have a worksheet which consists of 9 columns of alphanumeric data (columns A - I) which each contains alphanumeric data. Each column may have upto 2000 enteries.

The data generally consists of an alphanumeric string consisting of no more than 7 characters.

For example:

ABC123D
CDE456F
DFR789R

etc

Each column does have unique strings, however each columns is obvioulsy different.

Contained within some of the coumns may be some alphanumeric strings which are also present in other columns.

How would one find a way of establishing what these common strings are in each of the columns and presenting their frequency. It could be the case that a common string only appears in 4 out of the 9 sheets and may consist of more than one common string.

So for example in column M I would like to present on the duplicate strings which are present in the columns along with their respective frequency of occurance.

For example.

ABC123D - 5
CEF543E - 3

And so on.

Any help would be greatfully appriciated as this is a bit beyond me.

Steve