"rwfster" wrote:
Max, that formula works great for the A5 cell
That's good. But pl click the YES in that response

How can it be adapted to include evaluating cells A5 through E5?
I have tried adding A5:E5 and A5&B5&C5&D5&E5 without success ..

I wonder if you meant to do something like this
In say F5:
=IF(SUMPRODUCT(COUNTIF(Z$2:Z$100,A5:E5)),"X","")
where Z2:Z100 contains the criteria, ie the list of the possible values, and
A5:E5 is the range to be checked for the occurence of any of these criteria
values

Adapt to suit. As-is the expression can be copied down
to return correspondingly for A6:E6, A7:E7, and so on

Celebrate success? Click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---