View Single Post
  #1   Report Post  
Biff
 
Posts: n/a
Default

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
.