Hi,
I have a number of rows with a spreadsheet and i only want to take the row that meets certain criteria.
I have attached a copy of what i mean. The rows that are highlighted are the only rows i want to use as they have the total in.
So basically i want to say where the team, code and subtotal for team are then take this line of data.
EXAMPLE 2.xlsx
many thanks
Select the whole data then press Alt->D->B check mark which field need to subtotal after then drag down field "at each change in" as code then press o.K.
May be this is what you want.
Have a look at attachment.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Thank you. However is there a formula i can use as i want to try automate this process as.
Many thanks
This is quite simple and better than formula, however if you want to populate the results thru formulae then you will have to do much working before that.
You can see the attached file where i have used two formula.
1- For Unique code range in I column =IFERROR(INDEX($C$2:$C$10,MATCH(0,INDEX(COUNTIFS($I$1:I1,$C$2:$C$10),),0)),"")
2- For sum of unique total J & K column =SUMIFS(F$2:F$10,$C$2:$C$10,I2)
Or PT option is very simple which is best in all of them.
Have a look at attachment.
Thank you for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks