Mark last record of a particular name

J

jdb

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?
 
B

Biff

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top