+ Reply to Thread
Results 1 to 5 of 5

Index formula to return the results at the top of a column

  1. #1
    Valued Forum Contributor
    Join Date
    08-22-2011
    Location
    Auckland
    MS-Off Ver
    Excel 2019
    Posts
    716

    Index formula to return the results at the top of a column

    Hello People..
    I've been banging my head trying to work out how to get the formula to return the results at the top of a column & not somewhere further down as it does now. The attached example shows the results at different places down the column. I want the results to start at row 10 for every column I'm going to use.
    Any ideas?? I know it's easy when you know how.
    Thanks
    Attached Files Attached Files
    Last edited by Philb1; 02-16-2012 at 02:49 AM.

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Index formula to return the results at the top of a column

    Try, in E10:

    Please Login or Register  to view this content.
    confirmed with CTRL+SHIFT+ENTER not just ENTER and copy down.

    similar in other columns, replacing the >=2 and <3 as required.

    or if you place a 2 in E8 and 3 in F8, etc.. you can use formula as:

    Please Login or Register  to view this content.
    confirmed with CTRL+SHIFT+ENTER not just ENTER and copy down and across columns.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Valued Forum Contributor
    Join Date
    08-22-2011
    Location
    Auckland
    MS-Off Ver
    Excel 2019
    Posts
    716

    Re: Index formula to return the results at the top of a column

    Thanks NBVC.. That's what I'm after. I've been trying to get my head around array formulas & so far haven't found a tutorial that ends with a clear explanation & without leaving me hanging. They all seem to finish without telling you why it does what it does. A step by step would be good.
    I'll keep plugging away
    Thanks again
    Phil

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Index formula to return the results at the top of a column

    Have you checked this article: Array Formulas

  5. #5
    Valued Forum Contributor
    Join Date
    08-22-2011
    Location
    Auckland
    MS-Off Ver
    Excel 2019
    Posts
    716

    Re: Index formula to return the results at the top of a column

    Have now
    Cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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