If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Donna" wrote in message
...
If on my spreadsheet I break out a column that just has checks in (col A)
I
would like to in column (B) match all the places that the check is
applied. I
have used numbers in col (B) but if I could use the letters of the
alphabet
that would even be better, but either way would be a great help.
A B c d

1235 1 R $500.00
1795 2 R $150.00
1999 3 R $ 12.00
1795 2 R $545.00
2007 4 R $195.00
1235 1 R $100.00
1795 2 R $ 10.00
Thanks Donna