• 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.

Search results

  1. W

    Having a subtotal glitch in which it doesn't separate out a few records

    ohh... I didn't know you click on subtotal twice! And also uncheck the 'replace current subtotals' box. Thank you so much guys!! Much appreciated!! My problem is resolved now. :)
  2. W

    Having a subtotal glitch in which it doesn't separate out a few records

    Hi Sir, I've reload the experimentation file with a tab that has my initial subtotal try and I also uploaded a screenshot of what command check boxes I ticked against to derive what I got.
  3. W

    Having a subtotal glitch in which it doesn't separate out a few records

    Thank you SirJB7, but unfortunately I don't understand what you mean by 'removing previous subtotals (none)' as I don't see it in the subtotal box. Please see pic I uploaded to the folder. Could you please further explain? My data was already properly sorted alphabetically at the beginning...
  4. W

    Having a subtotal glitch in which it doesn't separate out a few records

    That's excellent! That's even better than what I was hoping for! Thanks! Could you please explain the steps to how you came by this result?
  5. W

    Having a subtotal glitch in which it doesn't separate out a few records

    Done. I've removed the previous subtotal commands and it's now plain data.
  6. W

    Having a subtotal glitch in which it doesn't separate out a few records

    VOTS-S and Sheet 1 are the same but please look at Sheet 1 and the data has already been sorted according to Staff Name alphabetically.
  7. W

    Having a subtotal glitch in which it doesn't separate out a few records

    Thanks Hui. https://skydrive.live.com/redir.aspx?cid=fd2b3a06a1ffee35&resid=FD2B3A06A1FFEE35!209&parid=FD2B3A06A1FFEE35!145&authkey=!ACGwV-VMit-6oGU Here it is. I hope I set it up correctly. Basically I've arranged it so that I get subtotal hours for every week ending for each...
  8. W

    Having a subtotal glitch in which it doesn't separate out a few records

    Hi Narayan, I used SUM, which calculated most of the entries correctly, except for these few lines. Would you like to have a copy of the spreadsheet to see for yourself? That might be easier.
  9. W

    Having a subtotal glitch in which it doesn't separate out a few records

    I have been generating reports with the Subtotal function so that I get the total of hours spent on a weekly basis (ie. week ending 15/4/2012) per project per consultant (ie. on average 25 consultants). However there are invariably a few week endings where it combines 2 consultants instead of...
  10. W

    Hello .. Introduce yourself

    Hi. I am Jennifer from Melbourne, Australia and I work as a PA in an IT firm that strangely (IMHO or is it just me??) doesn't seem to understand or use Excel alot! I was going to start learning VBA on my own but work demands took up my time. My background is media and communications but have...
Back
Top