+ Reply to Thread
Results 1 to 6 of 6

Get some cells from row -> same items

  1. #1
    Registered User
    Join Date
    12-03-2019
    Location
    Kambodza
    MS-Off Ver
    2016
    Posts
    3

    Get some cells from row -> same items

    I have table with many same name of items and types of items. How I can get only one cell from row where one cell have string "XXX"? There is many multiple items like:
    id name age color number
    1 xxx 32 red 100
    2 yyy 35 green 80
    3 yyy 35 green 80
    4 xxx 32 red 100
    5 yyy 35 green 80
    So for example I need find item by name and display age or number or all 3 values.
    Which one function will be the best?
    Attached Files Attached Files
    Last edited by MESSIAHH; Yesterday at 01:38 AM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    16,322

    Re: Get some cells from row -> same items

    Welcome to the forum

    Please 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.

  3. #3
    Registered User
    Join Date
    12-03-2019
    Location
    Kambodza
    MS-Off Ver
    2016
    Posts
    3

    Re: Get some cells from row -> same items

    Sorry. Now I add file.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    16,322

    Re: Get some cells from row -> same items

    On the Data Tab, click on Sort and Filter--->Advanced. Here is a picture of what you should do.

    v A B C D E F G H I J K
    1 id name old color number name old color number
    2 1 xxx 32 red 100 xxx 32 red 100
    3 2 yyy 35 green 80 yyy 35 green 80
    4 3 yyy 35 green 80
    5 4 xxx 32 red 100
    6 5 xxx 32 red 100
    Attached Images Attached Images

  5. #5
    Registered User
    Join Date
    12-03-2019
    Location
    Kambodza
    MS-Off Ver
    2016
    Posts
    3

    Re: Get some cells from row -> same items

    Sorry but I want find item by name from other file. How to find cell by name and display all entire row containing specific value name.

  6. #6
    Registered User
    Join Date
    10-22-2019
    Location
    Qatar
    MS-Off Ver
    2013
    Posts
    12

    Re: Get some cells from row -> same items

    Hi,
    I think "Vlookup" will help you.
    find the attached.

    If it's not satisfied you, upload your data sheet.
    We can try another solution.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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