Formula Needed

[baggarwal]

Hi All:

I have data in the following rows as follows:

Column A Column B Column C
DD
DD DD
Blank Blank Blank


There are about 12 more columns that could have DD or blanks.

I need to add a 13th column that will put in a DD if any one of the 12 columns has a DD a DD. Otherwise I want it to but in nothing. Can someone please recommend a formula that will do that.

The third row in this case would return a blank.

 

[Jonmo1]

Try

=IF(COUNTIF(A1:L1,"DD")>0,"DD","")


Hope that helps.