"driller" wrote:
thanks to all who help
You're welcome.
i just found out a milder formula like this with a CSE
=IF(AND(SUM(--(EXACT($C$1:$E$3,F6))),SUM(--(EXACT($C$1:$E$3,G6))),SUM(--(EXACT($C$1:$E$3,H6)))),IF(ISERROR((F6&G6&H6)+0),F 6&G6&H6,(F6&G6&H6)+0),"")
cheers , more power ^2!!!
It's a trade-off. Using SUM you do save on the keystrokes: "PRODUCT" x 3 =
21 keystrokes in total here, and that results in a shorter looking formula,
but it requires array-entry (CSE) unlike using SUMPRODUCT which doesn't
(normal ENTER will do). Just a matter of personal preference, of course <g.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---