Glad to hear. If there's the possibility of more than a single digit for the
"front number" in col D (eg: 11-option eleven), you could try something like
this instead:
=AND(B2="Committed",LEFT(D2,SEARCH("-",D2)-1)+0=5)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"murkaboris" wrote:
Thanks Max, got it working.
Monika