S
steev_jd
Hi,
I have a list that has has a list of entries and sub entries in colum
A.
Each sub entry is indented, as below
Column A --------------¬------Column B---¬
-(5 spaces)-ABING..............183427
-(7 Spaces)-ABING..............183423
-(7 Spaces)-PAVA.........................2
-(7 Spaces)-EURM.........................1
-(5 spaces)-AEGIS....................524
-(7 Spaces)-AEGIS....................524
-(5 spaces)-JAGA....................1000
-(7 Spaces)-JAGA.....................900
-(7 Spaces)-LEMA.....................100
-(7 Spaces)-GURM.....................15
I need to total the extra indented sections to see if the match th
less indented entry above them.
i.e. in the example above ABING and AEGIS would be correct, JAG
wouldn't
as 183426 = 183423+2+1 and 524 = 524
but 1000 does not = 900+100+15.
Does anyone have any suggestions as to how I can speed this process u
rather than calculating every section manually?
Thanks in advance.
Stev
I have a list that has has a list of entries and sub entries in colum
A.
Each sub entry is indented, as below
Column A --------------¬------Column B---¬
-(5 spaces)-ABING..............183427
-(7 Spaces)-ABING..............183423
-(7 Spaces)-PAVA.........................2
-(7 Spaces)-EURM.........................1
-(5 spaces)-AEGIS....................524
-(7 Spaces)-AEGIS....................524
-(5 spaces)-JAGA....................1000
-(7 Spaces)-JAGA.....................900
-(7 Spaces)-LEMA.....................100
-(7 Spaces)-GURM.....................15
I need to total the extra indented sections to see if the match th
less indented entry above them.
i.e. in the example above ABING and AEGIS would be correct, JAG
wouldn't
as 183426 = 183423+2+1 and 524 = 524
but 1000 does not = 900+100+15.
Does anyone have any suggestions as to how I can speed this process u
rather than calculating every section manually?
Thanks in advance.
Stev