Results 1 to 6 of 6

I need a formula that will distinguish blocks of data with sub headings as they are foud

Threaded View

  1. 04-15-2015, 09:05 AM #1
    john dalton
    john dalton is offline
    Forum Contributor
    Join Date
    04-02-2010
    Location
    penrith
    MS-Off Ver
    Excel 2007
    Posts
    522

    I need a formula that will distinguish blocks of data with sub headings as they are foud

    Hi I am requiring a formula that will take sub heading and allocate it to a list of data until the next sub heading appears and then allocate that to the next list of data and so on.

    Please see attached sheet for details.

    Any questions, please ask.

    John
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need a formula to count blocks of data
    By john dalton in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 04-15-2015, 08:57 AM
  2. Applying formula to consecutive blocks of data
    By Patrician in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-04-2014, 10:44 AM
  3. [SOLVED] This formula that I was given by my coordinator does not distinguish between,,,
    By laurabach in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-22-2013, 03:59 AM
  4. Formula or VBA code to restrict data entry to certain cells during 3 different time blocks
    By lazinia in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-06-2012, 04:09 PM
  5. Using macros to identify blocks of data and summarise those blocks
    By gophbeav in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2012, 04:35 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1