Getting a textvalue in A1 after filtering

[fraGment]

I have about 15 columns of data such data as Patients name birthday,
Albumin value, natrium value, weight value and more. Every i put in new
values for the same patients but keep the old records(rows) Its not so
nice having the same name about 40 times in a row(after filtering), so
i would like to only show the filtered name in ex "A1", and the rest of
the values in rows under that name. So far i havent found an easy way
to fix that.
anyone got an idea on how to fix it?
(sorry my english isnt so good)

 

[Dave Peterson]

How about just showing the first and hiding the subsequent (not quite what you
asked for, though).

If you want to try it, Debra Dalgleish has some notes at:
http://www.contextures.com/xlCondFormat03.html#Duplicate

But I wouldn't do it. If you do another filter on another column, you may not
be able to tell the person's name.