Results 1 to 4 of 4

Copy multiple cell contents to another cell, IF a condition is met

Threaded View

sted999 Copy multiple cell contents... 01-15-2014, 10:50 AM
Norie Re: Copy multiple cell... 01-15-2014, 10:59 AM
Kaper Re: Copy multiple cell... 01-15-2014, 11:04 AM
sted999 Re: Copy multiple cell... 01-15-2014, 11:24 AM
  1. #1
    Registered User
    Join Date
    03-16-2010
    Location
    Chesterfield, England
    MS-Off Ver
    Excel 2016
    Posts
    19

    Copy multiple cell contents to another cell, IF a condition is met

    Hi everyone.

    Sorry if this is a simple question, but this formula has defeated a colleague and I....and we have no idea what to try next!

    Basically, I have a table of employment circumstances. From the responses, I have added two columns on the end which performs some basic validation e.g flag if the respondent has said if they employed and unemployed. A simplified version of my data is below -

    ID Employment Unemployed Further study Unemployed and working, Unemployed and further study, Errors
    Person 1 Yes Yes No TRUE FALSE
    Person 2 No Yes Yes FALSE TRUE
    Person 3 No Yes No FALSE FALSE
    Person 4 Yes Yes Yes TRUE TRUE

    What I am now wanting to do is, where there is a TRUE in the validation columns, is to copy the column heading into the 'Errors' column - simply to provided a summary of the errors within the data. For example I need "Unemployed and working, Unemployed and further study," in the 'Errors' column for Person 4. As seen below.....

    Desired outcome
    ID Employment Unemployed Further study Unemployed and working, Unemployed and further study, Errors
    Person 4 Yes Yes Yes TRUE TRUE Unemployed and working, Unemployed and further study

    Any help would be greatly appreciated!

    Many thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 08-09-2013, 09:08 PM
  2. Insert Column Adjacent to Cell If Cell Contents Anything Other Than Condition
    By Jrub in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 03-20-2013, 03:45 PM
  3. Macro to copy the contents of a cell based on certain condition
    By Newbiee in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-09-2009, 01:29 AM
  4. Replies: 1
    Last Post: 03-18-2008, 07:03 PM
  5. [SOLVED] copy contents of multiple cells into a new cell - Help Needed Please
    By garyusenet@myway.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2006, 11: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1