Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default 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
  #2   Report Post  
Senior Member
 
Location: Philippines
Posts: 161
Default

Quote:
Originally Posted by Fracky View Post
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")
__________________
Asobi Wa Owari Da
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text string to Numeric string Manikandan[_2_] Excel Discussion (Misc queries) 2 March 12th 09 08:55 AM
Change 3 letter text string to a number string Pete Excel Discussion (Misc queries) 3 December 31st 07 07:47 PM
text comparision Blah Excel Discussion (Misc queries) 5 July 19th 06 02:13 AM
Splitting a text string into string and number mcambrose Excel Discussion (Misc queries) 4 February 21st 06 03:47 PM
Text String in Excel JBH Excel Discussion (Misc queries) 1 April 19th 05 01:27 PM


All times are GMT +1. The time now is 09:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"