LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JRD JRD is offline
external usenet poster
 
Posts: 60
Default Duplication of string values within a range

How do I check whether the same string value appears within a range of cells

e.g.

A
1 JD
2 DF
3 AM
4 FC
5 RS
6 DF
7 JD

How do I get excel to check down column A1:A7 to see if any of the different
strings are repeated? In this example I want to return the answer "yes"
because JD appears in both A1 and A7. However, if this wasn't the case then I
would want excel to return the answer "no"

I am using excel 2007

Many thanks

JD


 
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
Sum values in string in a cell Francis[_2_] Excel Worksheet Functions 12 May 9th 09 02:15 AM
Return a String in a 7 Row Range Q Sean Excel Worksheet Functions 6 October 6th 08 03:36 PM
convert a string to range? JK Excel Worksheet Functions 4 June 20th 06 01:04 AM
specify range name in formula with concatenated string Lori H Excel Worksheet Functions 2 July 19th 05 03:07 PM
Stop Number duplication in a range Nu-bEE Excel Discussion (Misc queries) 5 March 21st 05 04:23 PM


All times are GMT +1. The time now is 10:40 AM.

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"