+ Reply to Thread
Results 1 to 2 of 2

Finding a text in range of cells and collect the information

  1. #1
    Registered User
    Join Date
    07-26-2012
    Location
    muzaffarabad ak
    MS-Off Ver
    Excel 2003
    Posts
    30

    Question Finding a text in range of cells and collect the information

    hi there
    I want to find persons first name from a range of full names data, and want to collect the information found, i.e how many times the persons name is in the range and paste the information in specific rows. the data is in this format
    A B C D
    1 title of book English Mathematics Chemistry
    2 proof readers Mark John Michael Jackson John
    3 Antonio Sara Khan Kiano Rieves
    4 Matt Jimmy Wales Drew Houston
    5 Phil Libin Ben Silbermann Mark

    I want to add a formula next to the name's cell I want to search and find which books are proof reads by that person. i.e when I search Mark & Sara it will show me these results

    A B
    1 Mark English, Chemistry
    2 Sara Mathematics

    Kindly Guide me which formula to use.. and how

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Finding a text in range of cells and collect the information

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ 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] Finding nth word in a range of cells containing text
    By liblikas1990 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-16-2016, 05:47 PM
  2. Replies: 3
    Last Post: 01-26-2016, 08:28 PM
  3. Vlookup for finding parts of text in lookup range cells
    By brandnew22 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-18-2013, 11:20 PM
  4. [SOLVED] Finding median of range of cells containing text and numbers
    By _hs_ in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 04-18-2013, 12:23 PM
  5. Finding the range of cells that contain specific text
    By WerdnaSbbig in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-13-2012, 10:33 AM
  6. Collect information from 2 different cells in List Validation
    By coldanby in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 07-04-2011, 07:18 AM
  7. [SOLVED] Use VBA to collect information from Excel cells to av word documen
    By Øyvind in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2005, 04:05 AM

Tags for this Thread

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