You could fill in the blanks, as described he
http://www.contextures.com/xlDataEntry02.html
Then hide the duplicate entries with conditional formatting, as
described he
http://www.contextures.com/xlCondFor...html#Duplicate
SHexceluser wrote:
I have copied a list from a pivot table, so there are blanks. Is there a way
for me to sort, and maintain those blanks. For example I have a list that
looks kind of like this:
John Smith Red
Orange
Yellow
John Doe Green
Mary Peters Red
Purple
It is important to know that John Smith goes along with Red, Orange and
Yellow. But I want to be able to sort the page so all of the people that
only like one color are grouped together and all of the people with multiple
colors are grouped together.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html