+ Reply to Thread
Results 1 to 6 of 6

Small Excell function

  1. #1
    Registered User
    Join Date
    09-30-2013
    Location
    ny
    MS-Off Ver
    Excel 2010
    Posts
    3

    Small Excell function

    I need to find the small number of the product of two rows, for example
    A B C D
    Row 1) 2 4 7 8
    Row 2) 3 5 9 1

    I would like small like this = small((A1*A2,B1*B2,C1*C2,D1*D2),4)
    Result should be 6 but instead it is giving me an error.
    The idea is that i dont want to create a separate line with the products

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Small Excell function

    Why not..

    =MIN(A1*A2,B1*B2,C1*C2,D1*D2)
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Small Excell function

    Wouldn't the 4th smallest be 63 ?

    Anyway, try this array formula entered with CTRL + SHIFT + ENTER

    =SMALL(A1:D1*A2:D2,4)

  4. #4
    Registered User
    Join Date
    09-30-2013
    Location
    ny
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Small Excell function

    Thnak you JonMo, I wanted the smallest. Acel way works. DO you know a way, that it gives me the smallest and the position of the smallest?
    Thanks

  5. #5
    Registered User
    Join Date
    09-30-2013
    Location
    ny
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Small Excell function

    Do you know a way to get the position of the smallest in the array? Thanks

  6. #6
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Small Excell function

    =MIN(INDEX(A1:D1*A2:D2,0))
    and
    =match(min(index(a1:d1*a2:d2,0)),index(a1:d1*a2:d2,0),0)
    should do it
    Last edited by martindwilson; 09-30-2013 at 05:45 PM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ 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. merging eight small excell files, same columns,
    By denlander in forum Excel General
    Replies: 2
    Last Post: 12-19-2010, 11:35 PM
  2. small function
    By navigator25 in forum Excel General
    Replies: 2
    Last Post: 10-24-2008, 12:24 AM
  3. Small Function
    By windme in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-13-2008, 03:13 PM
  4. Min AND Small function
    By yakumo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-12-2005, 01:26 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