+ Reply to Thread
Results 1 to 13 of 13

Looking for a single text value and returning 1 or multiple text values in one cell

Hybrid View

  1. #1
    Registered User
    Join Date
    10-22-2014
    Location
    Amsterdam
    MS-Off Ver
    2010
    Posts
    21

    Re: Looking for a single text value and returning 1 or multiple text values in one cell

    Hey Mike,
    As you asked, I’ve tried to make a more realistic workbook of my data. But the problem does not occur in that file. So I found that extracting data from a pivot table is not the problem. I think it’s my original pivot table that causes the problem. But why and where I can’t figure out. Here is a photo of the code and the error line a(ii,1)=<subscript out of range>. Maybe it can help you to figure out what’s wrong.

    code with error line subscript out of range.JPG

    Due to upload limitations it’s not possible to upload my original file (to big).
    Now I found a workaround for the still existing problem in my original file, the only thing I can’t workout is how to put the data in a different column (not B but M).
    Hopefully you can help me with that last hurdle.
    Thanks.
    Marc
    Last edited by cramnij; 11-05-2014 at 06:02 AM.

+ 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. Looking for a single text value and returning 1 or multiple text values
    By cramnij in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-22-2014, 08:37 PM
  2. Replies: 2
    Last Post: 04-30-2014, 05:59 AM
  3. [SOLVED] Excel - Returning multiple values in a single cell that match criteria
    By amazinz2006 in forum Excel General
    Replies: 13
    Last Post: 01-25-2014, 09:35 PM
  4. Returning a value to a single cell based on multiple values elsewhere.
    By archieross in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-05-2012, 07:35 PM
  5. Replies: 3
    Last Post: 08-02-2010, 10:07 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1