Results 1 to 11 of 11

Array with multiple IF's:

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-24-2018
    Location
    Oregon, USA
    MS-Off Ver
    2010
    Posts
    104

    Array with multiple IF's:

    I'm looking for help with an Array formula that does the following:

    Generate a list of results that contain:
    The value "1400"
    The value "1700"
    Contains "-F"
    Contains "p"
    All of these within the same range.

    My use of arrays has been with dates, I've been grasping a basic understanding of them with the help I've received on this forum in the past. Any help would be appreciated.
    Attached Files Attached Files
    Last edited by Pepe Le Mokko; 01-02-2020 at 04:51 AM. Reason: Removed unnecessary title part

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to Multiple One Cell in an Array Value Identified by Text in Another Array
    By EverClever in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-31-2018, 03:45 PM
  2. Replies: 1
    Last Post: 01-04-2018, 01:07 PM
  3. Countifs on an Array Range using multiple criteria in an Array
    By Mysore in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-12-2016, 04:39 PM
  4. Pull sub array from array using multiple column_num values
    By SinJinQLB in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-25-2015, 05:37 PM
  5. Multiple Criteria search and COUNT FOR TEXT across multiple sheet ARRAY's
    By akaushik25 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-25-2014, 08:58 AM
  6. Find a value in an array and return multiple values in an adjacent array
    By tonbra in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2012, 08: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