jimrward
Well-known Member
- Joined
- Feb 24, 2003
- Messages
- 1,877
- Office Version
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
looking for clever formula to number up some data, tis easy with VBA
A
A
A
B
B
C
D
E
E
etc
as follows, so basically where data is the same increment by minor of 0.1, when different increment by major of 1, there should be no more than 9 items per group
A 1.0
A 1.1
A 1.2
B 2.0
B 2.1
C 3.0
D 4.0
E 5.0
E 5.1
etc
A
A
A
B
B
C
D
E
E
etc
as follows, so basically where data is the same increment by minor of 0.1, when different increment by major of 1, there should be no more than 9 items per group
A 1.0
A 1.1
A 1.2
B 2.0
B 2.1
C 3.0
D 4.0
E 5.0
E 5.1
etc
