Search:

Tag: small function

Search: Replies Views Search took 0.00 seconds.

  1. [SOLVED] How to find second smallest of a set of formulas in Excel 2007 Sheet?

    Started by Arun Prasad‎, 11-19-2023 12:08 AM
    excel & formula, min and max function, second largest, small function, smallest 1 Attachment(s)
    • 144
    Last Post: 11-19-2023 12:50 AM
    by HansDouwe  Go to last post

    Forum:
    Excel Formulas & Functions

  2. [SOLVED] Row-based lookup for zip codes forces reset at change of county name

    Started by Rex411‎, 08-05-2022 11:27 AM
    index function, one to many lookup, small function, zip code 1 Attachment(s)
    • 321
    Last Post: 08-05-2022 01:14 PM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  3. [SOLVED] Small Function with Multiple Criteria - OR function

    Started by Peelah‎, 02-10-2022 01:56 AM
    or function, small function 1 Attachment(s)
    • 436
    Last Post: 02-10-2022 12:40 PM
    by JohnTopley  Go to last post

    Forum:
    Excel Formulas & Functions

  4. [SOLVED] Need help averaging the lowest 16 scores out of 20 while discarding an entry of 0 (zero)

    Started by Vinnyfan‎, 08-19-2021 10:43 AM
    average formula, small function 3 Attachment(s)
    • 327
    Last Post: 08-19-2021 03:38 PM
    by Fluff13  Go to last post

    Forum:
    Excel Formulas & Functions

  5. SMALL function to exclude zero values?

    Started by TME‎, 01-28-2020 01:50 PM
    ignore 0 cells, small function 4 Attachment(s)
    • 7,084
    Last Post: 01-31-2020 05:15 PM
    by hemesh  Go to last post

    Forum:
    Excel Formulas & Functions

  6. [SOLVED] Need bottom 5 ranks with names | Bottom 5 performing players

    Started by mukuljain99‎, 11-23-2019 07:32 AM
    excel & formula, match & index, min and max function, small function, vlookup #min 2 Attachment(s)
    • 1,135
    Last Post: 11-24-2019 02:53 AM
    by mukuljain99  Go to last post

    Forum:
    Excel General

  7. [SOLVED] Return a list from a table with multiple values per line

    Started by Manwithaplan‎, 02-27-2019 06:46 PM
    aggregate function, create list, small function 2 Attachment(s)
    • 708
    Last Post: 02-28-2019 12:25 AM
    by Bo_Ry  Go to last post

    Forum:
    Excel Formulas & Functions

  8. [SOLVED] Struggling with a lookup that returns the last non zero value from a row

    Started by Hinchliffe2012‎, 03-27-2018 12:16 PM
    if function, index match, lookup, small function, vlookup 1 Attachment(s)
    • 1,243
    Last Post: 03-28-2018 09:26 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  9. Lookup multiple values with multiple criteria, fill horizontally same row by header

    Started by ophizer‎, 09-29-2017 04:44 PM
    index match matrix, multi column, multi dimensional array, multi dimensional lookup, small function 2 Attachment(s)
    • 507
    Last Post: 09-29-2017 05:20 PM
    by ophizer  Go to last post

    Forum:
    Excel Formulas & Functions

  10. [SOLVED] Listing ALL entries of index/match (not just first entry)

    Started by Peelah‎, 04-24-2017 01:30 AM
    index and small, multiple answers, small function 2 Attachment(s)
    • 643
    Last Post: 05-15-2017 04:20 PM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  11. [SOLVED] Pull data horizontally and place vertically 3 by 3

    Started by 80Wil‎, 04-06-2017 01:20 PM
    extract data, horizontally, int function, mod function, small function 7 Attachment(s)
    • 1,049
    Last Post: 04-13-2017 01:15 PM
    by FDibbins  Go to last post

    Forum:
    Excel Formulas & Functions

  12. Rows to Columns Transpose Error

    Started by Excell1677‎, 08-14-2016 12:39 AM
    index and match function, small function, transpose 1 Attachment(s)
    • 732
    Last Post: 08-14-2016 02:48 AM
    by Excell1677  Go to last post

    Forum:
    Excel Formulas & Functions

  13. find the best 3 values with multiple variables

    Started by pivottc‎, 06-11-2016 12:29 PM
    pivot table, small function 1 Attachment(s)
    • 563
    Last Post: 06-11-2016 02:09 PM
    by gmr4evr1  Go to last post

    Forum:
    Excel Formulas & Functions

  14. Return Multiple corresponding values for Single Lookup Value, Horizontally

    Started by ljhyun89s‎, 02-24-2016 05:01 PM
    index, small function, vlookup 1 Attachment(s)
    • 1,665
    Last Post: 02-24-2016 06:14 PM
    by Tony Valko  Go to last post

    Forum:
    Excel Formulas & Functions

  15. [SOLVED] Multiconditional lookup incorporating the SMALL function accross both X and Y axis

    Started by MattRNR‎, 09-19-2015 08:09 AM
    index & match, lookup, multiconditional, small function 4 Attachment(s)
    • 1,053
    Last Post: 09-26-2015 07:11 AM
    by MattRNR  Go to last post

    Forum:
    Excel General

  16. [SOLVED] Displaying more than one result vertically

    Started by holli‎, 05-12-2015 02:38 AM
    small function
    • 549
    Last Post: 05-13-2015 02:19 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  17. [SOLVED] How to use Arrays in Functions like LARGE / Conditional Range

    Started by mastertonn‎, 08-30-2014 01:40 AM
    array, array formula, condition, large function, small function 1 Attachment(s)
    • 1,015
    Last Post: 08-30-2014 02:40 AM
    by sktneer  Go to last post

    Forum:
    Excel General

Results 1 to 17 of 17

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1