+ Reply to Thread
Results 1 to 2 of 2

Extract Values in Column S into Column R (Desired Output Column)

  1. #1
    Forum Contributor
    Join Date
    02-06-2013
    Location
    Maryland
    MS-Off Ver
    Excel 2010
    Posts
    1,000

    Extract Values in Column S into Column R (Desired Output Column)

    Looking for formula to extract values in column S into Column R (Desired Output Column)

    1. Column S is where the values to be extracted are located.

    2. The values to be extracted in column S must take into account column Q23 (our first occurrence of 1 for Dorman, David W.) and then fill it down to the last row that correspond to Dorman, David W. name in column D.

    3.Formula Adjustment:
    Please Login or Register  to view this content.
    This formula
    Please Login or Register  to view this content.
    is in column O. Would like it adjusted because it is not working properly. Its first occurrence in O22 = $P$44 should start in O23 by taking into account column P23 (P23 = 2008)

    See attached sample file.

    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,425

    Re: Extract Values in Column S into Column R (Desired Output Column)

    If I understand the intent of column S correctly then pasting the following into S2 and copying down should produce the desired results (matching what is in column R):
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] Partial Search to Extract values in a Table (column A2:C142) into column K2:L24
    By bjnockle in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-10-2020, 03:45 PM
  2. VBA find unique values from input multiple column to output new column
    By lotto009 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2020, 12:50 AM
  3. Replies: 8
    Last Post: 03-29-2020, 01:00 PM
  4. [SOLVED] Formula Required to Extract data from Column A based on Non -zero values in Column B
    By Ramzan-ul-Mubarak in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-29-2019, 06:07 AM
  5. [SOLVED] How to extract values in one column based on criteria in another column
    By TimLarson in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-27-2019, 07:06 PM
  6. Replies: 2
    Last Post: 10-05-2018, 08:28 AM
  7. [SOLVED] need formula to this logic, A column number B column blank then C column desired name
    By vengatvj in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 11-02-2013, 10:30 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