IF column A contains ANY text OR IF column B contains ANY text..

Closed

Pete - Mar 6, 2016 at 08:45 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 8, 2016 at 11:26 AM

Hello,

I'd like to achieve in Open Office Calc

IF column A contains ANY text then ADD "XYZ" into cell G12 OR
IF column B contains ANY text then ADD "ABC" into cell G12 OR
IF column C contains ANY text then ADD "QRS" into cell G12 OR
IF column D contains ANY text then ADD "TUV" into cell G12 OR
IF column E contains ANY text then ADD "DEF" into cell G12.

Thanks very much

Open Office Calc

IF column A contains ANY text OR IF column B contains ANY text..
Excel copy column from one sheet to another automatically - Guide
Sum column if another column equals ✓ - Excel Forum
Conditional formatting if cell contains text in another column ✓ - Excel Forum
How to increment numbers when value changes in another column? - Excel Forum
Auto serial number in excel based on another column ✓ - Excel Forum

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Mar 8, 2016 at 11:26 AM

Hi Pete,

You mean something like this?:
=IF(COUNTIF(A:A,"*")>0,"XYZ",IF(COUNTIF(B:B,"*")>0,"ABC",IF(COUNTIF(C:C,"*")>0,"QRS",IF(COUNTIF(D:D,"*")>0,"TUV",IF(COUNTIF(E:E,"*")>0,"DEF")))))

Best regards,
Trowa

Similar discussions

VBA find column by name and sort

Auto generate serial number in excel based on Column

Converting rows of data in notepad to columns

How to copy the Column value into Rows

Counting number of times a value appears if..

Similar discussions

Subscribe To Our Newsletter!