Results 1 to 14 of 14

Repeating IF?

Threaded View

  1. #1
    Registered User
    Join Date
    02-03-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    32

    Repeating IF?

    Hi,

    I wonder if anyone can help me, on the attached spreadsheet there is a list of codes for different divisions which I need to group together in one cell separated by |. Obviously this can be easily done but I need for anyone divisions with "not quoted" to be skipped out without leaving a space or anything. An example of how I want it to look is on the right under the title "Answer needed for the system in 1 column". I've had a go (in green) but don't know how to get the IF to repeat itself. Does anybody know how to do it either this way or another way? I will eventually need to apply it to a large amount of data. Please let me know if this doesn't make sense.

    Thanks in advance for any help you can give me.
    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. Repeating averages
    By pepsi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-16-2015, 09:03 AM
  2. [SOLVED] Without repeating numbers
    By thair in forum Excel General
    Replies: 6
    Last Post: 05-20-2012, 03:12 PM
  3. creating a repeating formula that doesn't show repeating values
    By cybershot in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-09-2010, 06:12 PM
  4. Repeating a seven row sum
    By TheLazyUpstart in forum Excel General
    Replies: 4
    Last Post: 08-11-2009, 06:17 AM
  5. Repeating sequences
    By TheExile in forum Excel General
    Replies: 3
    Last Post: 06-02-2008, 08:33 AM
  6. non-repeating bg
    By stewart08 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-02-2008, 06:20 AM
  7. Repeating
    By Lynn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-07-2005, 01:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1