On Mar 10, 9:58 am, "Max" wrote:
Paul,

As David explained, an OR is required, expressed indicatively as:
((Cond1)+(Cond2)+(Cond3)+...)

Hence the part in your expression should look like this:
... *(('Grid data'!F2:F4557="NS")+('Grid data'!F2:F4557="C")+
(TRIM('Grid data'!F2:F4557)="")))
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik
---

Thanks Guys, it works perfectly
Paul