Results 1 to 4 of 4

Multiple Small Queries

Threaded View

  1. #1
    Registered User
    Join Date
    09-03-2013
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    96

    Multiple Small Queries

    Hi everyone,

    I have a series of numbers that are posted as results in column M:M,
    If a target is met it will result in the data from A2 being posted,
    using the small function it works with singular numbers,
    Obviously doing something wrong, hence the reason for trying to learn more here.

    The formula I'm trying to use is:
    =IFERROR(IF(SMALL(M:M,1),A2,"",IF(SMALL(M:M,2),A2,"",IF(SMALL(M:M,3),A2,"",IF(SMALL(M:M,4),A2,"")))),"")

    How do I join these together?
    =IF(SMALL($M:$M,1),$A$2,"")
    =IF(SMALL($M:$M,2),$A$2,"")
    =IF(SMALL($M:$M,3),$A$2,"")
    =IF(SMALL($M:$M,4),$A$2,"")

    Excel 2016 version, is there an easier way to do this?

    Many thanks in advance,
    Chad
    Last edited by chad328; 08-17-2016 at 06:56 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 01-21-2013, 12:47 PM
  2. Embedded Access queries in Excel - if the database moves, how to update queries?
    By Paul_mcc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-06-2012, 07:52 PM
  3. Multiple Web Queries
    By eros18 in forum Excel General
    Replies: 2
    Last Post: 12-01-2011, 01:59 PM
  4. Multiple web queries
    By skazis in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-29-2011, 07:11 AM
  5. Multiple MIN queries
    By SAsplin in forum Excel General
    Replies: 1
    Last Post: 05-09-2011, 05:19 AM
  6. VBA for Multiple web queries
    By gsav in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-11-2011, 03:21 AM
  7. Multiple queries
    By Simon Shaw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2005, 05:06 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