ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Text string comparision within excel (https://www.excelbanter.com/excel-discussion-misc-queries/265936-text-string-comparision-within-excel.html)

Fracky
Text string comparision within excel
 
Hi,

I would like to compare text within a cell to several other cells and return a 'Yes/No' answer. e.g cell A1 has 'Bob' within, I would like to compare the content cells in B1, D1 and J1 and if the one of these 3 cells has the same content return, 'Same', otherwise 'Investigate'.

Thanks

wickedchew
Quote:
Originally Posted by Fracky (Post 959500)
Hi,

I would like to compare text within a cell to several other cells and return a 'Yes/No' answer. e.g cell A1 has 'Bob' within, I would like to compare the content cells in B1, D1 and J1 and if the one of these 3 cells has the same content return, 'Same', otherwise 'Investigate'.

Thanks
=IF(COUNTIF(B1:J1,A1)=1,"Same","Investigate")


All times are GMT +1. The time now is 01:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com