I have a table full of different records, but many of them have the same value in Column1. What I want to do is get a count of all the duplicate values in Column1.
So for example, if Column1 has the data:
I want the output to show:
Test1 = 3
Test2 = 1
Test3 = 1
I know it’s going to require some while loops, I just don’t know where to begin. Thanks guys.