Hello All,

Objective: I am looking to create a macro that will generate a report on a seperate worksheet.
Relative forum posts:
http://www.excelforum.com/excel-form...n-a-table.html
http://www.excelforum.com/excel-prog...n-a-table.html

Let's say it looks something like this:
(column
A B C):
x x x
y y z
z y z

I can have as many instances of "x" and "y", but I can only have 1 "z" per column. The reoccurences in a row do not matter, just the column.
In my example above, I have provided an example of what I need, and what I need to identify. In Column A, there is only one occurence of "z". However, in column B and C, Column B is missing a "z" and Column C has more than 1 "z".

How can I create a macro that will generate a report on a new worksheet which identifies if the column has either one too many z's, or no "z".

I will stop here for now because I don't want to overwhelm anyone with too many information or even confuse myself as I write this, if you have any questions please ask.

Thank you all for your support,

akhaN