+ Reply to Thread
Results 1 to 6 of 6

Locate cell vertically adjacent to another cell based on cell values

  1. #1
    Registered User
    Join Date
    01-06-2010
    Location
    Little Rock, AR
    MS-Off Ver
    Excel 2007
    Posts
    12

    Locate cell vertically adjacent to another cell based on cell values

    In column A, the data entered from a pull-down menu ranges from values of A to Z. I'm trying to find all instances where one cell contains in the vertical cell next to it a specific combination such as "B" and "L." For example, the column may show

    A
    P
    Y
    B
    L
    S

    In advance, I appreciate your help.

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Locate cell vertically adjacent to another cell based on cell values

    Not clear.

    What result do you expect?
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    01-06-2010
    Location
    Little Rock, AR
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Locate cell vertically adjacent to another cell based on cell values

    Sorry.

    I'd like Excel to lead me to all instances where B is in a cell immediately above or below L.

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Locate cell vertically adjacent to another cell based on cell values



    Sorry, I'm completely lost on your request.

  5. #5
    Registered User
    Join Date
    01-06-2010
    Location
    Little Rock, AR
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Locate cell vertically adjacent to another cell based on cell values

    Let me present it this way:

    The following is listed in column A:

    Tree
    Sky
    Bird
    Leaf
    Rock
    Tree
    Tree

    I'm trying to conduct a search of the spreadsheet to find all instances where "Bird" comes just before the word "Leaf" as it does in the example.

  6. #6
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Locate cell vertically adjacent to another cell based on cell values

    Quote Originally Posted by shawnkey View Post
    I'm trying to conduct a search of the spreadsheet to find all instances where "Bird" comes just before the word "Leaf" as it does in the example.
    OK, then what?

    What will be the result of your search?

+ 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. Replies: 1
    Last Post: 09-10-2014, 08:21 PM
  2. [SOLVED] VBA help needed to Fill cell values based on Adjacent Cell values
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-06-2014, 07:08 AM
  3. [SOLVED] copy cell values in one cell based on value of adjacent cells
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-20-2014, 08:48 AM
  4. [SOLVED] Adding values based on value of adjacent cell...
    By Finalfrontier1976 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-13-2013, 09:20 AM
  5. [SOLVED] Scan cells, locate a certain text and add the adjacent cell
    By randomintel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-17-2013, 10:24 AM
  6. Calculations based on adjacent cell values
    By Jack in forum Excel General
    Replies: 4
    Last Post: 06-10-2006, 09:45 AM
  7. Replies: 1
    Last Post: 11-17-2005, 02:35 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