Loop through groups of unique identifiers and perform counting actions on other columns

Hi,

I'm attempting to come up with a script that loops through groups of unique identifiers in Column A and performs some actions based on the contents of other columns (I can probably work out my own code for much of it, just not identifying the groups).

For example, sample data:

Column A Unique ID	Column B
00001	0
00001	0
00001	0
00001	1
00002	0
00002	3
00002	3
00002	1
00002	0
00002	2
00002	1
00003	3
00003	3
00003	1

How could I loop through these so that I find the highest number in column B for each of the unique identifiers? Probably best if the answer is delivered to another sheet so the unique identifiers are not reproduced. From this starting point I hope I can flesh out the rest of my queries like spitting other things in to more columns etc (low, average, counts, etc).

Column A Identifier	Column B Highest Number
00001	1
00002	3
00002	3

Can try SQL way too:

Please Login or Register  to view this content.

Small correction on Jindon's code when Sheet1 is Activesheet when executing code.

Please Login or Register  to view this content.