Hi,
Thank you very much for your answers. Though unfortunatley having the
entries in a seperate list or deleting the spaces won't help.
The list is laid out as such
-<5 spaces PARA ¦ 100-
<7 spaces HERT ¦ 80
<7 spaces KULR ¦ 20
-<5 spaces GIHI ¦ 5-
<7 spaces JUBS ¦ 2
<7 spaces TEFT ¦ 2
-<5 spaces JMLU ¦ 500 -
<7 spaces HTYE ¦ 250
<7 spaces ERWE ¦ 150
<7 spaces FERT ¦ 100
and I have to check that the value of the 5 spaced items equals the
total of 7 spaced items mentioned beneth
i.e. above PARA and JMLU would be fine, GIHI wouldn't.
Do you have any furter ideas?
(the entries may have more than 4 letters)
Regards,
Steve
--
steev_jd
------------------------------------------------------------------------
steev_jd's Profile:
http://www.excelforum.com/member.php...o&userid=33107
View this thread:
http://www.excelforum.com/showthread...hreadid=569919