+ Reply to Thread
Results 1 to 3 of 3

Formula to seperate breaks

  1. #1
    Registered User
    Join Date
    08-20-2021
    Location
    Wigan
    MS-Off Ver
    365
    Posts
    2

    Formula to seperate breaks

    Good Afternoon

    Please see attached. I have a resource docuemnt that needs a little tweek.
    Currently my formaul shows the resource heads and when lunch is scheduled. I need to incorperate 3 other breaks.

    Can anyone help.


    Ian
    Attached Files Attached Files

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Formula to seperate breaks

    You don't stipulate what you want to return in your matrix for the breaks, for simplicity I have just returned the headers for time being...you should find you can adjust easily enough (incl. CF rules)

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-20-2021
    Location
    Wigan
    MS-Off Ver
    365
    Posts
    2

    Re: Formula to seperate breaks

    This is brillaint, thnak you

+ 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. Formulas and Line Breaks - inserting mid-string & removing excess breaks
    By MattDay2u in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-24-2017, 09:54 AM
  2. Clear all page breaks, then insert new breaks at change in data
    By Alex0929 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-09-2014, 03:12 PM
  3. [SOLVED] Macro to seperate worksheets to seperate workbooks fired from external excel file
    By optionone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-26-2012, 01:25 PM
  4. Macro to print each row on a seperate page with cell line breaks.
    By sjknight in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2012, 04:22 PM
  5. Hard page breaks being replaced by soft breaks in the wrong place
    By JDavies in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-14-2008, 10:28 AM
  6. Hard breaks in text to soft breaks in Excel
    By tbailey in forum Excel General
    Replies: 6
    Last Post: 07-27-2005, 10:05 PM
  7. Hard breaks in text to soft breaks in Excel
    By tbailey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2005, 12: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