+ Reply to Thread
Results 1 to 2 of 2

Need help - Need a formula to extract data when certain criteria is met

  1. #1
    Registered User
    Join Date
    04-14-2017
    Location
    Plymouth, minnesota
    MS-Off Ver
    2016
    Posts
    35

    Need help - Need a formula to extract data when certain criteria is met

    I need help with a formula. I have a spreadsheet attached. This is showing transactions that happen on our shift at work. Im looking for a formula that will extract the entire row from columns A through H into columns K through R if certain criteria is met -
    Find all the duplicates in column E, if the name in column A is different on each row of those duplicates then copy the row of each duplicate from columns A through H into columns K through R.
    In my example I highlighted the 4 rows that have duplicates in column E and column A has a different name. When the happens those rows should be copied into rows K through R if possible.
    Attached Files Attached Files

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Need help - Need a formula to extract data when certain criteria is met

    as a way: autofilter, COUNTIF
    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)

Similar Threads

  1. Replies: 8
    Last Post: 05-08-2016, 12:48 AM
  2. Replies: 0
    Last Post: 05-02-2016, 07:59 AM
  3. Dynamic Formula Extract Data For Multiple Criteria - Version 2
    By Karroog in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-28-2016, 01:38 PM
  4. [SOLVED] Formula to extract given criteria from a table
    By ssdsibes in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-14-2015, 06:36 AM
  5. formula to extract row based on criteria
    By keith740 in forum Excel General
    Replies: 4
    Last Post: 06-21-2015, 10:41 AM
  6. Replies: 3
    Last Post: 12-18-2014, 10:27 AM
  7. [SOLVED] Dynamic Formula Extract Data for multiple criteria
    By Karroog in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-13-2014, 04:08 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