wickedchew wickedchew is offline

Senior Member

Location: Philippines

Posts: 161

Quote:

Originally Posted by Fracky

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 08:08 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us