Automatic numbering when rows inserted or deleted but with a difference

Hi everyone,

I'm hoping someone can help please. I'm producing a catalogue using easycatalog. Items will be added as I go along within different sections of my spreadsheets

I've learnt recently how to make automatic numbering when inserting or deleting rows which works a treat.

But while still using this technique I also need to make automatic numbering for another column on the same spreadsheet.

In most circumstances it will be 1.2, 1.3, 1.4 etc but occasionally I will need the same number to follow each other ie. 1.2, 1.3, 1.4, 1.5, 1.5, 1.5, 1.5. This will be determined by a product of the same name.

At a loss how to do this and if it's even possible.

I hope you understand what I'm after.

Thanks

Thank you here it is

Oh dear thank you PaulM100, I'm so rubbish at Excel that was all double dutch :-( I'll try and work out what you mean, thanks again