+ Reply to Thread
Results 1 to 3 of 3

List using curly brackets (braces) in formula to create a list

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    610

    List using curly brackets (braces) in formula to create a list

    Hi,
    I've been experimenting with using curly brackets (after watching tutorial, excelcampus) to create return multiple columns in
    an index function.
    Look up area B4:G13
    INDEX(B4:G13,SEQUENCE(ROWS(B4:G13)),{4,3,1})

    to return column 4 then 3 then 1.
    I've also looked at the match function to return multiple results;

    MATCH(M2:O2,B4:G4)

    My question is ; can someone explain or tell me where I can find information on how these work for example 'index({1,3,4},2,3,5}) returns R1C2,R3C3,R4C5.

    I've attached the file I've been messing with 'sheet 2 ' better. I know it's a bit vague but in help gratefully recieved.
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: List using curly brackets (braces) in formula to create a list

    Would you explain what you are trying to use this for and add the results you expect.

    Typically an INDEX function returns the value at an intersection of a row and column.
    If you're wanting to analyse a data range like you have then a Pivot Table with some Slicers to filter it would seem the obvious solution.

    To answer your specific question why Index({1,3,4},2,3,5) returns R1C2,R3C3,R4C5,, was that a typo since that returns an error. Did you perhaps mean Index({1,3,4},{2,3,5})
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: List using curly brackets (braces) in formula to create a list

    Not sure what this formula is meant to be index({1,3,4},2,3,5}) but even if it's meant to be index({1,3,4},{2,3,5}) then it cannot return R1C2,R3C3,R4C5. For the simple reason there is only one row & 3 columns, so it would return 3,4,#REF!

+ 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. Replies: 9
    Last Post: 11-06-2019, 08:56 AM
  2. [SOLVED] Sumif with Curly Braces { }
    By marathonrunner in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-29-2018, 06:19 AM
  3. How to add array formula that contains curly braces using VBA?
    By Rerock in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2015, 01:17 PM
  4. curly braces
    By Faridwahidi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-02-2014, 12:48 AM
  5. [SOLVED] Can I update Multiple Forumlae With Curly Braces All At Once?
    By stuu3270 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-20-2013, 03:50 PM
  6. What do curly brackets /braces {} do in VBA
    By Huugin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-17-2012, 04:33 PM
  7. [SOLVED] Curly Brackets in formula view
    By VBSK8R in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-04-2012, 09:32 AM

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