Dynamic Number

Question

Dynamic Number

Version: Numbers 3.5.2

OS: 10.10.3

Wondering if there is an easy way to do some "dynamic numbering" in Numbers. I have a lot of names in various cells after which I have a three letter alphacode and then I want a numberical code. For example:

Column 1:

Row 1: apple (MIR01)

Row 2: ball (MIR02)

Row 3: car (MIR03)

etc.

So it's the number portion after MIR I'm trying to automate, so if I was to delete row 2 with ball that car (MIR03) would change to MIR02. Or conversely if I was to add a row somewhere in between 02 and 03 so car would change to MIR04 automatically that would be awesome!

If anyone has any good ideas of where I might

Posted on Apr 27, 2015 7:49 PM

Reply

Answer 1

t quinn

Level 5

7,043 points

Apr 28, 2015 6:24 AM in response to JonathanSmith2006

Hi Jonathan,

ONe approach to this would be to use the ROW() function.

If you want this all in one cell your item ("apple", etc..) would take the place of "A1" in this example. Note that you do not have leading zeros in this solution.

To get leading zeros You would need to add a column with a custom format. The formula in that column is simply ROW().

You could still eliminate the A column by putting the item withing the formula.

quinn

Reply