+ Reply to Thread
Results 1 to 2 of 2

Searching single column and placing values in adjacent column

  1. #1
    Registered User
    Join Date
    11-21-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    33

    Searching single column and placing values in adjacent column

    A B
    10th St E08 10th St E08
    11th St E08 11th St E08 11th St E09
    11th St E09
    12th St E08 12th St E08 12th St E09
    12th St E09
    13th St E08 13th St E08
    15th St E08 15 St E08 15th St E10
    15th St E09
    15th St E10


    Column A is my current Data. Column B is what I would like the results to show as. If there are 3 or more original values in column A(15th St), I would like to have the lowest and highest values show in column B.
    Thank you in advance
    Last edited by Huskersippi; 11-21-2012 at 06:33 PM.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Searching single column and placing values in adjacent column

    Hi Huskersippi,

    Suggest you to go through below thread :-

    http://www.excelforum.com/excel-form...e-returns.html

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

+ 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