Results 1 to 5 of 5

Array to put results in one column in to one cell

Threaded View

  1. 04-16-2017, 09:52 AM #1
    Karnik
    Karnik is offline
    Forum Contributor
    Join Date
    06-24-2012
    Location
    Australia
    MS-Off Ver
    Office365
    Posts
    302

    Array to put results in one column in to one cell

    Hi Experts,
    Would appreciate any suggestion for array to put 1 to 4 cells (max) results from one column in to one cell.

    TOTAL No. Rank
    10 1 4
    20 1
    30 1 2
    40 1 1

    Last column results to put in one cell as 4,2,1, or 421

    Attached sheet may assist clearly
    Thanks in advance
    Karnik
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. [SOLVED] how can i make this array change the cell in a column based on a text array
    By dmcgov in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-25-2016, 09:44 AM
  2. [SOLVED] Find cell in 2nd array using row and column from the first array Excel 2010 VBA
    By crywolf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-08-2015, 02:12 PM
  3. How to make Vlookup or return results that are not in the first column of the array?
    By c.mayer in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-18-2014, 08:14 PM
  4. [SOLVED] Index/Match Array with multiple results concatenate in one cell
    By samiesosa in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-15-2013, 01:34 PM
  5. [SOLVED] Array formula to filter a results set only matches first value in the array
    By ulthima in forum Excel General
    Replies: 6
    Last Post: 05-26-2012, 04:56 AM
  6. Lookup data in array, results in column 1
    By dslomski in forum Excel General
    Replies: 3
    Last Post: 02-23-2009, 10:49 AM
  7. [SOLVED] Wanting to write results to array instead of sheet, results overwriting....
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2005, 10:05 AM

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