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

Recent content by Trader273

  1. T

    Highlight columns 2 at a time, alternating

    I think this is what you are looking for: https://www.dropbox.com/s/01neaoj9e0nb6j4/Color%202%20Columns%20at%20a%20time.xlsx Uses conditional formatting to color two columns at at time.
  2. T

    Display dates across row, excluding Sundays

    Don't feel too bad, sometimes what can appear to be easy can elude us. Anyways, here's what I cam up with: https://www.dropbox.com/s/0ommx45oc26jvfe/No%20Sundays.xlsx
  3. T

    Using a key to return multiple values

    Could mess around with formulas, but easier and quicker to just use a pivot table with a slicer or filter.
  4. T

    Clickable Drilldown Pie Charts

    Also, might want to reconsider using pie charts as they can be easily misunderstood by the target audience
  5. T

    Learn charting

    The important thing is to start slow. Star with the basics and then build up from there. Starting off by looking at the tax burden chart, which is pretty advanced, is going to cause you nothing but frustration as you dont have a solid foundation yet. Though, just spending a few days and...
  6. T

    Certification

    I would stay away from 3rd party certs, they could good to help you learn more, but I would just go with a cert actually from microsoft. http://www.microsoft.com/learning/en/us/mos-certification.aspx They offer 2 excel tests, one is specialist and one is an expert. If you have any sort of...
  7. T

    Tally How many Members are interested

    I think PowerPivot will be a great course. The more I use and mess around with the more I realize how powerful it really is. Looking forward to that one for sure.
  8. T

    Different row fields for different values in pivot table?

    You could always use the GetPivotData function. Might have to use two or more pivot table, but then just build one using the function of everything you want
  9. T

    Time calculation

    3.5 <> 3 and 1/2 minutes. If you put in 3:50, then your calculation comes out correctly.
  10. T

    Throw out the high and low

    Hopefully this helps: https://www.dropbox.com/s/up85yf0z01o8tqx/Average%20without%20Outliers.xlsx
  11. T

    Calculated Field that counts unique values

    if you have your data and pivot table how you like it, then I'd look into the GetPivotData Function. Gives you all the nice things that come with pivot tables, while allowing you to use "regular" formulas.
  12. T

    Display message in chart if no data is available

    See if this points you in the right direction: https://www.dropbox.com/s/8fml9ulw1dnh5ay/Show%20Pie%20when%20Data.xlsm
  13. T

    Sumifs on Rows

    This should be what you are after. I showed two ways of getting what you want, hopefully lol. Personally, pivot tables are a lot easier. https://www.dropbox.com/s/hmy1lhii227cqho/Sumifs%20vs%20Pivot%20Table.xlsx
  14. T

    Restart Numbering on a reaching a certain value

    Wasnt 100% clear of what you wanted, so this may or may not help. Just used the MOD function https://www.dropbox.com/s/kg31m1xa2o6j7t2/Reset%20Numbering.xlsx
  15. T

    Publish Dashboard with Slicer as Interactive Webpage

    Building upon what Montrey suggested. This link should be a good start. http://office.microsoft.com/en-us/sharepoint-server-help/introduction-to-excel-services-and-excel-web-access-HA010105476.aspx
Back
Top