Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Different graphic for each record in mail merge document | Charts and Charting in Excel | |||
Scatter chart x axis tick mark lables | Charts and Charting in Excel | |||
How do I save a record from an excel template to a database in a . | Excel Discussion (Misc queries) | |||
How do I find a template to record client information? | Excel Discussion (Misc queries) |