Ask Your Question

replace identical values in same column with unique identifier [closed]

asked 2014-11-07 14:15:15 +0200

bennypr0fane gravatar image

I have a worksheet where lots of cases have the same value in that column (B) that is actually supposed to serve as a primary key when importing this file into a database, i.e. no value in this column/variable must be the same as any other, so that value can serve to identify the case. Here's a screenshot:

look at column B

How can I automatically replace all values in this column with numbers 1-207?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-05 22:10:57.026562

1 Answer

Sort by » oldest newest most voted

answered 2014-11-07 14:34:42 +0200

karolus gravatar image


fill Column B with Formula: =ROW()
fülle Spalte B mit der Formel =ZEILE()


edit flag offensive delete link more


Is it possible to fill each cell of the whole column with the same content in one step, or define a function to be valid for the whoel column, or would I just have to do this 207 times over? Also If I use this method, won't the cell numbers change if I rearrange the lines? The value in the cell shouldn't be affected by changing the position of the line.

bennypr0fane gravatar imagebennypr0fane ( 2014-11-07 22:39:59 +0200 )edit

Question Tools

1 follower


Asked: 2014-11-07 14:15:15 +0200

Seen: 445 times

Last updated: Nov 07 '14