My first post here, probably with many more following, but I am having trouble visualizing this code, so I will simply explain what I am doing.

I have a pivot table, grouped twice and with a count on the right side. Example below. What I want to do is index these in some way, and find out when the top half of the lettered values are greater than the bottom half. For example, I would like for it to return for Item1, Top Half < Bottom Half (the amount of the values on the right column), and vice versa for the next two. The challenge is that the lettered values are not consistent (some will go A to D, some A to E). Is there an easy way to do this, or am I just going to have to write a mile of code? Thanks for any help, this forum has been a wealth of knowledge for me recently for learning VBA for Excel.
Item1
A | 10
B | 15
C | 5
D | 10
Item2
A | 20
B | 5
C | 40
Item3
A | 30
B | 20
C | 30
D | 30