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

    VLookup or Match?

    Arrays can seem a little intimidating at first since it's something a little different that requires a little different thinking. But once you really get into them, you will probably use them a lot more than you would have realized.
  17. T

    A better pivot table

    Not a problem at all. I havent used these too often, but since all the columns are coming from 1 field in the pivot table, whatever you set the number format (right click in pivot table-value field settings-number format) is what will be for the entire table. So if you change that to percent...
  18. T

    A better pivot table

    Oops sorry about that. That's an easy fix 1) Active Pivot Table Wizard - Multiple Consolidated Ranges - I will Create Page Field 2) Highlight each data table, and hit "Add" --Lets Use Product A as an example for the remaining: 3) In the ALL RANGES, select the first range you added that...
  19. T

    The ultimate mug

    HAHA, that is awesome. My wife thinks I'm a huge nerd as it is, but this just might seal the deal. Though I do like it a lot!
  20. T

    A better pivot table

    See if this helps. Used the often forgot about PivotTable Wizard in order to make 1 pivot over multiple data tables. I include a How-TO in the file, much easier to put in there. Also, did this pretty quick so would probably need some tweaking, but could be a good start...
  21. T

    create loop for main range

    Here's what I took from your initial question: https://www.dropbox.com/s/fmzhu5cge4ph9zj/Multiple%20Loops.xlsm if not 100% what you are looking for, least should be a starting point.
  22. T

    create loop for main range

    Seems like it should be pretty easy, but not following 100%. Any change you could post some same data of what you want to accomplish?
  23. T

    extracting data from string

    if you want to go the vba route, the string functions (InStr, StrComp, StrConv) are perfect for what you want. Just depends on if you want to go that way or not.
  24. T

    Extract from Access to Excel

    LOL, I suppose at times it can. But the more I go into it, the more logical things get. Not for everyone, thats for sure.
  25. T

    Extract from Access to Excel

    not a problem at all. I know how frustrating it can get. Really starting to get into T-SQL. Not sure how involved you want/need to get, but just picking up a book or two on T-SQL and sql server really helped.
Back
Top