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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 8, 2016 at 11:26 AM
Related:
- 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
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Mar 8, 2016 at 11:26 AM
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
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