+ Reply to Thread
Results 1 to 3 of 3

How to use formulas/functions to retrive values of multiple rows in each column? (attach)

  1. #1
    Registered User
    Join Date
    06-16-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    4

    How to use formulas/functions to retrive values of multiple rows in each column? (attach)

    Dear user,

    I would like to seek for help please.
    Please refer the the attachment.
    How to use formulas/functions (no vba) to retrive values of multiple rows for each person in each column? Thanks.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    05-09-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    259

    Re: How to use formulas/functions to retrive values of multiple rows in each column? (atta

    What would you like to see in cell E2? all of those numbers? not quite sure what you are wanting as a result

  3. #3
    Registered User
    Join Date
    06-16-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: How to use formulas/functions to retrive values of multiple rows in each column? (atta

    Hi HurricaneFly,

    In cells E2:E5, I like to see same numbers as in A2:E5 by using formula functions (i.e. INDEX? Match? Offset?), no VBA, vlookup or hlookup.
    Is it possible?
    Last edited by hhppyy; 06-16-2013 at 06:53 AM.

+ 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