how to number cells with specific numbers

Microsoft Office excel 2007 - upgrade
October 15, 2010 at 03:13:16
Specs: Windows XP
Dear everyone,
I would like to ask you one question that seems quite easy when seen, but for me, very hard to solve as I haven't found any formula solving it. Please help, if you know how to do it..

Here it is. I have a sheet with product numbers (2000 - 3000). Some of them are repeating, some of them are not. I need to write in the column next to it a number like this: If there is one product number, write 1, if there is second one after, write 2 and so on.

It should look like this:
2001 1
2002 1
2003 1
2003 2
2003 3
2004 1
2005 1
2005 2
2005 3

I very appreciate your help.
With kind regards,

See More: how to number cells with specific numbers

Report •

October 15, 2010 at 04:35:25
Assuming your data starts in A1, try this formula.

Note the placement of the dollar sign. As you drag the formula down, the top of the range stays constant but bottom will increase, thereby counting each occurrence the referenced value in the range above it.


Report •
Related Solutions

Ask Question