+ Reply to Thread
Results 1 to 6 of 6

how to return multiple values vertically

  1. #1
    Registered User
    Join Date
    07-12-2021
    Location
    Seoul, Korea
    MS-Off Ver
    2016
    Posts
    2

    Post how to return multiple values vertically

    Hi guys,
    I am stuck and confused at the moment.
    Hope you guys could lend me some brightness.
    I have attached my working sample book, and I want to return multiple values vertically on my result tab which conditions match
    should I use SMALL or ROW function? or not?
    and how should it be applied? please kindly help out gracias
    Attached Files Attached Files
    Last edited by blackhound; 07-12-2021 at 01:49 AM. Reason: title change

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    7,687

    Re: how to return multiple values vertically

    IN B3 copied down

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  3. #3
    Registered User
    Join Date
    07-12-2021
    Location
    Seoul, Korea
    MS-Off Ver
    2016
    Posts
    2

    Re: how to return multiple values vertically

    Dhanyadagalu kvsrinivasamurthy
    one more question to ask, is it essential to lock the range field $A$2:$A$30 ? or could I extend to whole field A:A ?

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    7,687

    Re: how to return multiple values vertically

    You can extend the range to A:A but it will slow down calculation. Itís better to use fixed range like A2:A400000 with sufficient margin.

  5. #5
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    7,687

    Re: how to return multiple values vertically

    Thanks for feedback and rep.

  6. #6
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Malaysia
    MS-Off Ver
    365 V2301 and WPS V2022
    Posts
    2,622

    Re: how to return multiple values vertically

    worksheet name : RESULTS

    Cell B3 array formula , Drag down

    HTML Code: 

+ 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. Index/Small Functions
    By RichMW in forum Excel General
    Replies: 3
    Last Post: 01-07-2019, 04:53 PM
  2. IF Functions with Small and Large Functions? Not Sure
    By HDBrewer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-11-2016, 03:56 AM
  3. SMALL/LARGE functions...
    By rachandsouza in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-27-2015, 06:33 AM
  4. Functions similar to SMALL or overcome limitations of SMALL
    By arvindtechie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-05-2013, 10:59 AM
  5. [SOLVED] if+small functions question
    By Alexander_Golinsky in forum Excel General
    Replies: 2
    Last Post: 06-26-2012, 11:34 AM
  6. What is fastest for this? The Small VBA or many Worksheet Functions...?
    By Maria J-son in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 PM
  7. [SOLVED] What is fastest for this? The Small VBA or many Worksheet Functions...?
    By Maria J-son in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM

Tags for this Thread

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