Previous Topic Next Topic

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

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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
0

Similar discussions

Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses
VBA find column by name and sort
SidK -
bOFILL -

4 responses
Converting rows of data in notepad to columns
Need help -
Philgood_FR -

2 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Excel Macro/Code help: Creating sheet for each name in column of another sheet
excelnovice2019 -
vcoolio -

21 responses