excel macro

Hi,
Could someone tell me how to compare excel field to see if the field is the same and if so increment a counter. ? Thanks

[JimmyT]

I've done a lot of work with Excel Spreadsheets, Macros, and controlling spreadsheets from VB. I don't understand what your question really is, or what you are trying to accomplish. Please provide additional details and I will try to assist you.

If I understand your question right you would like to compare one cell to another cell and increment a counter if the values of the two cells are the same. In Excel you may be able to use the 'Match' function. You may have to look it up in Help since it has been a while since I've programmed in Excel.
Basically what this function does is compares two cells and returns, I believe, the row number of the matching cell. If it doesn't find a "match" it will return an error.

I hope this helps a little anyway - good luck