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