+ Reply to Thread
Results 1 to 3 of 3

If a group of cell contain a certain text

  1. #1
    Registered User
    Join Date
    09-22-2014
    Location
    England
    MS-Off Ver
    MS Excel 2010
    Posts
    62

    If a group of cell contain a certain text

    Hi All.

    I have attached an example.

    I want to have my example to see if what text i have in C3 appears in D6:F6 and if it does then return what is in C6 as text.

    So i have done the first example. If the text in C3 John appears in the list of employees in week one then return the contents of C6 (Test)

    Hope this is clear.

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,639

    Re: If a group of cell contain a certain text

    Try this.....
    In G6
    Please Login or Register  to view this content.
    and copy down.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,639

    Re: If a group of cell contain a certain text

    Thanks for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to group text in a cell
    By Dewdrop in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-13-2014, 09:19 AM
  2. Replies: 1
    Last Post: 02-10-2014, 10:26 PM
  3. [SOLVED] Record if there is any text in a group of cells
    By u5e10 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-14-2012, 11:43 AM
  4. Group or Add text
    By mrcois in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-10-2010, 08:50 AM
  5. text in shape group
    By pshen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2005, 03:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1