# 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 12002 12003 12003 22003 32004 12005 12005 22005 3I very appreciate your help.With kind regards, Peter

See More: how to number cells with specific numbers

#1
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.=COUNTIF(A\$1:A1,A1)

Report •
Related Solutions