+ Reply to Thread
Results 1 to 15 of 15

Collating Information but exclude errors

Hybrid View

  1. #1
    Registered User
    Join Date
    11-14-2011
    Location
    Bournemoth England
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Collating Information but exclude errors

    So the end result I want is -

    Cooperation, Curriculum Linked Activities, Familiarization, Fun, Personal Challenge, Personal Development, Personal State Management, PSE, Self Belief, Skill Acquisition, Support, Training Course

    BUT...

    It needs to be depandant on the #N/A's as it could change too -

    Cooperation, Curriculum Linked Activities, Familiarization, Fun, Personal Challenge

    I can get it so the end result is - Cooperation, Curriculum Linked Activities, Familiarization, Fun, Personal Challenge, Personal Development, Personal State Management, PSE, Self Belief, Skill Acquisition, Support, Training Course, , , , , , ,

    But need to exclude these last commas.

    Hope that makes sense

  2. #2
    Registered User
    Join Date
    11-14-2011
    Location
    Bournemoth England
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Collating Information but exclude errors

    So sheet one is a matrix - that 1 Signifies it matches that point - Sheet 2 refers that to a Number to reflect the Lookup.

    Sheet 4 is where having the issue - (I have proberly gone the long way round it all)

    I have Sorted - I want to combine as mentioned above to give result such as -

    Cooperation, Curriculum Linked Activities, Familiarization, Fun, Personal Challenge, Personal Development, Personal State Management, PSE, Self Belief, Skill Acquisition, Support, Training Course

    Hope that abit more useful
    Attached Files Attached Files

+ 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. Add EXCLUDE Option in table to Exclude from Solver
    By lbofbb in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-17-2015, 09:05 AM
  2. Replies: 8
    Last Post: 10-31-2014, 12:03 PM
  3. [SOLVED] dynamic named range drop-down list to exclude N/A errors
    By tlacloche in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-07-2014, 11:51 AM
  4. collating information
    By Back2Basics in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-04-2008, 01:46 PM
  5. Collating information in a different location
    By tom300181 in forum Excel General
    Replies: 3
    Last Post: 08-04-2005, 04:03 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