I have a spreadsheet that is about 1200 rows long. The first column contains
names of funds, and the other columns contain different information about
them. To extremely simplify what I'm trying to do, take the following list
for example.
A
A
B
B
B
C
D
D
This is what my first column looks like. I'd like to have Excel search
through and put blank rows between the dissimilar groups so that it looks
like the following
A
A

B
B
B

C

D
D
Any Ideas? This is going to take me a long time to do manually... and then
I want to make those blank rows color too, but doing that manually isn't
quite as bad. Thanks All