+ Reply to Thread
Results 1 to 4 of 4

Arrange data by Name in an arrayed data set

  1. 08-31-2015, 08:22 AM #1
    chris_94
    chris_94 is offline
    Registered User
    Join Date
    08-20-2015
    Location
    Melbourne, Australia
    MS-Off Ver
    MAC
    Posts
    10

    Question Arrange data by Name in an arrayed data set

    Hi all!

    I got some help before about getting my data sorted, and I used an array formula. Now on my sheet 2, which shows what is "on loan" from my sheet 1, I want to organise the data so that it is sorted by name - so i can easily see who has what.

    Is this possible? I have attached the spreadsheet if that helps.

    Many thanks!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-31-2015, 08:43 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,557

    Re: Arrange data by Name in an arrayed data set

    By FAR, the easiest way to do this is to sort the data in the Equipment Register into alphabetical order (column E). the Index-Match array that you already have will keep the alphabetical order perfectly on the second sheet.

    is that OK for you?
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  3. 08-31-2015, 01:23 PM #3
    popipipo
    popipipo is offline
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,332

    Re: Arrange data by Name in an arrayed data set

    Or try a pivot table
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong
    Reply With QuoteRegister To Reply
  4. 08-31-2015, 07:39 PM #4
    chris_94
    chris_94 is offline
    Registered User
    Join Date
    08-20-2015
    Location
    Melbourne, Australia
    MS-Off Ver
    MAC
    Posts
    10

    Re: Arrange data by Name in an arrayed data set

    Thanks guys, a little bit tricky but it works! Thank you
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Arrange multiple periods with data to one vertical period with data
    By coolboy3222 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 11-10-2013, 05:00 PM
  2. Arrange multiple periods with data to one vertical period with data
    By coolboy3222 in forum Excel General
    Replies: 1
    Last Post: 11-06-2013, 11:21 AM
  3. arrange data
    By cassiopea in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-09-2011, 10:55 AM
  4. Arrange data
    By ordinateur in forum Excel General
    Replies: 7
    Last Post: 02-17-2010, 12:53 PM
  5. Arrange Data
    By RemyD in forum Excel General
    Replies: 3
    Last Post: 05-07-2009, 02:00 PM
  6. Data Re-arrange
    By Miles Willis in forum Excel General
    Replies: 2
    Last Post: 11-27-2006, 02:35 PM
  7. [SOLVED] Excel Flavour in a Named Formula, Regular or Arrayed ?
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-06-2005, 05:20 AM
  8. how to split data into columns and arrange the resulting data
    By jack in forum Excel General
    Replies: 1
    Last Post: 11-11-2005, 07:25 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1