Mark last record of a particular name
 

I am using KnowledgeBase article ID #105888 to Merge a Conditional Number of
Records.

In the article, it shows a sample data file which lists a number of names.
Some of the names are listed multiple times (they are sorted so each name is
'grouped'). in a new column, they give the last occurance of each name a
unique identifier (in this case, a '1').

How do I do this?
--
Joe

Hi!

I don't know about that article but one way to do this is
to use this formula:

=IF(A1=A2,"",1)

This simply tests the next cell to see if it is equal to
the previous cell.

Biff

-----Original Message-----
I am using KnowledgeBase article ID #105888 to Merge a
Conditional Number of
Records.

In the article, it shows a sample data file which lists a
number of names.
Some of the names are listed multiple times (they are
sorted so each name is
'grouped'). in a new column, they give the last
occurance of each name a
unique identifier (in this case, a '1').

How do I do this?
--
Joe
.