Need to group and get the total page count per Group - Example attached - Please HELP!!
I am trying to get the total page count per group. In the example below, the total should be 2 for acct 6,7 and 9. Act 1 should be 1. In each group, we need to page number to start at 1. Please see example for act 176, 178 and 2.
Act Grpid GP# Page total
176 13 2 1 2
176 13 3 2 2
178 13 8 1 2
178 13 9 2 2
2 15 10 1 2
2 15 11 2 2
6 15 12
6 15 13
7 15 16
7 15 17
8 15 50
9 15 24
9 15 25
Hi and welcome to the forum
This is 1 of those times when a copy/paste of your data here, doesnt quiite show it as you want
I think countif() works in 2003, take a look and see if that will give you wnat you want. If not, we will have to use sumproduct(). For that, attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
The file is attached. Please review.
Thanks!!
Im not exactly sure how you get the number of pages,but this ARRAY formula will give you the max pages for each account...
=MAX(IF($A$2:$A$14=A2,$D$2:$D$14,0))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
I am getting the same result of 2 for total pages each grouping which is incorrect. For account no 8, the total should be 1.
How are you calc'ing the number of pages?
I copied the formula
=MAX(IF($A$2:$A$14=A2,$D$2:$D$14,0))
tried to copy down to the end...also, tried to ctrl - shift and enter but nothing happened.
All that will do is return the MAX value in column D, it is not calculating how many pages you will need. Thats why I asked how you would calc pages needed?
I need the calculation by grouping and account. In other words, the total number of pages should be 2 for the group and the page number would 1 and the second page is 2.
Make sense?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks