Results 1 to 3 of 3

Thread: search and display rows
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Feb 2019
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default search and display rows

    Dear all,
    I have a table with 34 columns and a couple hundred rows. In column no. 5 there in a name that repeats from time to time.
    In a different sheet i want to make a formula that searches the last row where that name appears in column 5 and display that entire row.
    Is this possible to make?
    if yes, can you help me with some hints how to do this?
    Thank in advance!

  2. #2
    Board Regular
    Join Date
    Jan 2014
    Location
    Dublin, Ireland
    Posts
    1,421
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: search and display rows

    below is a formula, i have assumed your table starts in column A and ends in AH, also the name of the sheet where your table is is Sheet1.

    =LOOKUP(2,1/(Sheet1!$E$1:$E$1000="Name"),Sheet1!A$1:A$1000)

    put the formula in A2 and copy across. This could slow down your excel however.
    Learn something new everyday.

    be sure to use code tags

    Code:
    [ code ]
    [ / code ]
    ' no spaces

  3. #3
    New Member
    Join Date
    Feb 2019
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: search and display rows

    thanks but this does not display the entire row. i need a formula that displays in Sheet2 the entire row that contains the last "Name".

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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