Reputation
1,123
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
4 11 32
Newest
 Enlightened
Impact
~244k people reached

Jan
18
comment How to simulate a full outer join in Excel?
@ejbytes most people understand the concept of spreadsheets. Most do... not understand the concept of a database. I had a project converting a spreadsheet-as-database project to a database and the users still called it "the spreadsheet" - even after extensive explanations for how a database works!
Jan
13
awarded  Enlightened
Jan
8
answered How do I get the last worksheet in Excel VBA?
Jan
8
awarded  Good Answer
Jan
7
comment How to simulate a full outer join in Excel?
@Kyle I added that option to my answer. It's not for the faint of heart and for this might be a mess to play and/or complete overkill with but hey, why not!
Jan
7
revised How to simulate a full outer join in Excel?
added 2118 characters in body
Jan
7
awarded  Mortarboard
Jan
7
comment How to simulate a full outer join in Excel?
@T.J.L. if you format a table as a table, it'll use that sort of notation for referencing other columns. Much clearer than cell references. It might be a 2010+ feature? I'm not sure. I didn't use the magic of formatting as table enough prior to 2010..
Jan
7
awarded  Nice Answer
Jan
7
answered How to simulate a full outer join in Excel?
Jan
7
answered need duplicates with the merged header column
Jan
7
comment need duplicates with the merged header column
There are plenty of ways to do this with formulas. The problem is we don't know what the full scope of "this" the OP wants to do is, not that they cannot do it with formulas.
Jan
7
comment need duplicates with the merged header column
This isn't clear at all what you need. I can think of many ways to trivially accomplish what I think you are asking, but right now, with only this sample data and no explanation as to what you are trying, it's not enough information to actually know what you want.
Nov
15
reviewed Reject How to rename network printer on Windows 7?
Sep
23
comment Create a recurring appointment in Outlook for the Friday of every month after second Tuesday
This will work perfect for me, thanks!
Sep
22
awarded  Famous Question
Sep
8
awarded  Famous Question
Aug
18
comment In VirtualBox can't get max display resolution for guest OS
Wow you'd think I would have thought of something this obvious.
Aug
11
comment How can I apply environment variables without reboot?
Restarting the program which was accessing the environment variable did the trick for me!
Jul
2
awarded  Yearling