Help

Formula column and auto number concatenation

1706 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Stephen_Hauck
6 - Interface Innovator
6 - Interface Innovator

I have a Sheet…
Work items … it is related to customers …

In the Work items sheet I have a field that has this formula in it …
Customer & “-” & AutoNumber

I want the auto number to be 1 more than the customers last work item for that customer and not the next auto number … is there an easy way to do this ?

Customer 1
Work item 1
Work item 2
Work item 3

Customer 2
Work item 4
Work item 7
Work item 8

Customer 3
Work item 5
Work item 6

What I want is this
Customer 1
Work item 1
Work item 2
Work item 3

Customer 2
Work item 1
Work item 2
Work item 3

Customer 3
Work item 1
Work item 2
Work item 3

1 Reply 1
TFP
6 - Interface Innovator
6 - Interface Innovator

I’d also like to do something like this, but doesn’t seem doable.