On Mar 10, 11:15*pm, "Max" wrote:
welcome, good to hear that.
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik
---
<paultedder wrote



Thanks Guys, it works perfectly
Paul- Hide quoted text -

- Show quoted text -

Promise this will be the last question. You've given me some ideas and
I'm going crazy with alternate options.

On the following formula I am not getting the right results. It
appears to be ignoring the search for "NON" in column E.

=SUMPRODUCT((('Grid data'!B2:B4557=A2)*(ISERROR(SEARCH("shine*",'Grid
data'!D2:D4557)+(SEARCH( "non*",'Grid data'!E2:E4557))*((('Grid data'!
F2:F4557="NS")+('Grid data'!F2:F4557="C")+(TRIM('Grid data'!
F2:F4557)="")))))))

With your expert eye, can you see the issue as I'm wearing my nails
down trying to see it

Paul