Results 1 to 8 of 8

Advanced FILTER Function to Extract Data Subject to Conditions

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-08-2005
    MS-Off Ver
    Microsoft 365
    Posts
    841

    Advanced FILTER Function to Extract Data Subject to Conditions

    Hi,

    In A1:K16 I have sample data from which I want to extract the results in A22:K27.

    A product code will only have a row in the results if the sign (positive or negative) of the value in column F differs from that in column G AND/OR the sign of the value in column J differs from that in column K.

    For example:

    Product AAA is included in the results because the sign of its value in F2 is positive while its value in G2 is negative
    Product EEE is included in the results because the sign of its value in J6 is negative while its value in K6 is positive.
    H22:K22 and D23:G23 are blank for AAA and EEE, respectively, because the sign of their values in J2 and K2 and in F6 and G6 are the same.
    BBB is not among the results as both of the sign of its values in F3 and G3 and in J3 and K3 are the same.

    Can someone please suggest a FILTER function formula to achieve the results in A22:K27 (or some other solution)?

    Thanks!
    Attached Files Attached Files
    Last edited by andrewc; 02-07-2022 at 12:13 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA to Extract Data using advanced Filter
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-26-2019, 10:01 AM
  2. [SOLVED] Advanced Filter Between Two Columns all OR conditions (4 conditions)
    By nobodyukno in forum Excel General
    Replies: 2
    Last Post: 02-16-2017, 01:13 PM
  3. Replies: 7
    Last Post: 11-17-2016, 08:26 AM
  4. [SOLVED] conditions for advanced filter
    By ammartino44 in forum Excel General
    Replies: 3
    Last Post: 08-29-2015, 10:24 AM
  5. Extract data using Advanced Filter and VBA
    By vadivel77 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-08-2015, 12:22 PM
  6. [SOLVED] Advanced Filter - extract data to new sheet
    By schnautza in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-28-2014, 02:43 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