Thanks Pete. The only problem with this formula is that, while it does
remove the redundancies from column B, it does not remove the rest of the
line. There are about ten columns of information on each line relating to
each name and, although the names disappear (except for 1), the blanks are
accompanied by the other nine columns of information which had been
associated with the redundant name (which of course is information identical
to each redundant anme).

How can I leave a clean spreadsheet of just one line (10 columns of
information)
per unique single name?
--
Templar


"Pete_UK" wrote:

Suppose your names are in column A and that you have a header row so
that your data starts on row 2. Insert a new column B, and put this
formula in B2:

=IF(B2=B1,"",B2)

Copy this down as far as required. You can then hide column A so that
you have the effect you wanted, but the full names are still there if
required for other formulae (eg producing summaries for each person).

If you really want to you can fix the values in column B and then
delete column A. To fix the values, highlight column B, click <copy,
then Edit | Paste Special | Values (check) | OK then <Esc.

Hope this helps.

Pete

On Oct 3, 11:22 am, Templar wrote:
For the sake of discussion, let's say you have ten entries of the same
person, same address etc on lines 1-10. You want to eliminate this
redundancy and reduce
this to just one entry of that persons name and address. Is it possible for
me to
eliminate the other 9 lines and retain just 1 line?

Thank you.
--
Templar