Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2012
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Taking a variable break based on change in naes over an entire column

    I can get examples of how to take a break IFBLANK, but I want to take a subtotal in another column, based on a change in name.
    How do I do that. Theexamples all use constants (e.g. B1).

    Here's my PDL way of designing the formula:
    IF( ($B n+1) NOT EQUAL TO $B N), SUM the numbers in Col. F from the LAST time a break was taken to this cell and print in Col. G.

    That means that last cell's position must be recorded somewhere.

    Jack
    Jack
    Jack
    Jill
    Jill
    So when thecontents of Col. B change, take a subtotal on the contents of Col F, based on the interval between Jack 3and Jill 2.
    But all of this must be couched in a variable term based on which row we're on.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,224
    Thanks
    14
    Thanked 341 Times in 334 Posts
    Perhaps something like this in G2:
    =IF(B2=B3,"",SUM($F$1:F2)-SUM($G$1:G1))

    Then copy it down the column.

    Steve

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •