How do you auto number?
I want to auto number a spreadsheet but I can't seem to get the formula right. I want to number the rows based on the neighboring cells. If the first name and last name match then number it the same then move on. Can someone help me in the right direction please? I would like the numbering to look like this:
1 John Doe
1 John Doe
2 Jane Doe
3 Frank Johnson
4 Ralph Smith
4 Ralph Smith
4 Ralph Smith
Last edited by xcentric; 04-30-2007 at 12:28 AM.
|