View Single Post
 
Old 04-11-2018, 08:25 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

In D2 try:

=IF(COUNTIF(A2:C2,"X")>0,"X","")

Then copy formula down.

or you can use =IF(OR(A2="X",B2="X",C2="X"),"X","")

This latter formula is okay for 3 columns, but if you have lots of columns to check the former formula becomes the better choice.
Reply With Quote