2012-12-11, 08:30 #1
- Join Date
- Dec 2012
- 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.
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.
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2012-12-11, 10:02 #2
- Join Date
- Jul 2002
- Pittsburgh, Pennsylvania, USA
- Thanked 338 Times in 331 Posts
Perhaps something like this in G2:
Then copy it down the column.