+ Reply to Thread
Results 1 to 2 of 2

arrayformula with index and small function in google sheeet

  1. #1
    Registered User
    Join Date
    01-25-2019
    Location
    chennai
    MS-Off Ver
    2010
    Posts
    1

    arrayformula with index and small function in google sheeet

    hi all,
    i have to display the highest 3 ranks and corresponding name of the first three rank students (note: if two students got first rank means, i have to display the two students name).

    my formula i have tried is: =ArrayFormula((INDEX($B$5:$B$9,SMALL(IF($C$5:$C$9=MAX($C$5:$C$9),ROW($C$5:$C$9)-1),ROW(C5)-1))))
    iam getting the error :#NUM! -> 'Function SMALL parameter 2 value 4 is out of range'. in google sheet

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: arrayformula with index and small function in google sheeet

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ 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, IF and ROW function
    By hjhjhj in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-17-2023, 01:44 AM
  2. I need help using Match, Index, and ArrayFormula.
    By kulich in forum Excel General
    Replies: 4
    Last Post: 12-07-2018, 06:44 AM
  3. Converting index arrayformula from Google Sheets to Excel
    By Kibson in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-03-2018, 10:07 AM
  4. How do I convert an INDEX SMALL array formula for use in Google Sheets?
    By sharadmaxwell in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 7
    Last Post: 07-25-2018, 08:40 AM
  5. Google Sheets 'Arrayformula' with nested 'Importrange' formula Excel Equivalent?
    By Tamarissa in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 07-10-2018, 04:13 PM
  6. arrayformula from google doc to excel
    By shinkirou in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-04-2013, 11:51 AM
  7. Replies: 4
    Last Post: 08-05-2010, 01:09 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