• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula to add lines

K

Kinoyo

New Member
Hello, I am new to the forum and boy do I need help


I have to format reports by finding the subtotal a of various classes of items. The files are sorted by class so I was hoping there was a formula that I could use to notice when the class number changed and add a line to separate the classes at those points (a sum formula would also be helpful in the newly created line).


Is something like this possible? It would save me hours!


Thanks.
 
Hi Kinoyo ,


I am not sure I have understood you , but if you merely want to introduce subtotals whenever the class changes , can you not use the in-built subtotal feature of Excel ?


Select your data range , click on Data , Subtotal , Class , ....


This will add a SUBTOTAL row to your data whenever the class changes , and that row will contain the subtotal figures.


Narayan
 
You must log in or register to reply here.
Back
Top