Reputation
2,352
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
10 23
Impact
~445k people reached

Mar
11
awarded  microsoft-excel
Mar
8
answered MS Excel - How to select a radioButton when click on cell not on the radioButton itself
Feb
25
awarded  Popular Question
Jan
18
comment Excel VLOOKUP with named range not working
Great observation by Barry
Jan
17
answered Excel VLOOKUP with named range not working
Jan
16
comment Excel VLOOKUP with named range not working
the named range you say is $A$4:$B$6 but $A$4:$B$7 in the formula example. What is in D5?
Jan
10
awarded  Custodian
Jan
10
reviewed Approve Replace a path in many text files in linux
Jan
3
answered Excel worksheets not seeing their VB code
Dec
18
comment Windows 8.1 can't access internet through VPN
This may not be your issue, but it was mine. I had the same exact issue where it was not the vpn that was a problem but the network stack was damaged oyam.ca/blog/2011/11/windows-miniports
Dec
18
comment Windows 7 clock out of sync?
Is this machine part of a domain and possible getting the time from a domain time server?
Nov
19
comment Excel VBA SQL Query Handles Error
What version of excel and how much data might come back
Oct
19
awarded  Yearling
Sep
24
awarded  Autobiographer
Sep
4
comment VLOOKUP using dynamic workbooks in VBA
Is the name of the workbook2 is always the same, is the data range it contains always the same? When workbook2 is created does it have named range for the data. If there is consistency, or if you can always name a working copy of workbook2 the same, you can probably define it's data range and your vlookup formulas can remain unchanged.
Aug
30
comment Moving Right When Dragging Formula Down
This does seem more elegant, and not having a volatile formula is a better approach. Thanks for a better answer
Aug
29
comment Is there a formula I can use to count the number of occurrances of a name in 1,2,3 order?
this works well and you can make this draggable by changing the first formula to =countif($A$1:A1,A1) and drag it down
Aug
29
comment Excel - How can I collapse data, eliminating blank rows?
Values have to be non-blank for ALL three rows?
Aug
29
answered Moving Right When Dragging Formula Down
Aug
29
comment Moving Right When Dragging Formula Down
Copy down meaning the B changes to C? and in the next row C changes to D?