Hi
I have rows of data representing drawing numbers within various projects. Each row includes a Project Number in the format n.nn.n and a Sequential Number, format nnnn, within each of those projects. So you could have:
1.03.1 0001
1.03.1 0002
1.11.1 0001 etc
I need to be able to calculate...