Reputation
2,529
Top tag
Next privilege 3,000 Rep.
Cast close and reopen votes
Badges
1 8 19
Newest
 Enlightened
Impact
~411k people reached

Dec
27
answered Why can't you use special characters in a filename, like “?” or “;”?
Dec
19
comment List installed personal certificates in command line
possible duplicate of How can I get a list of installed certificates on Windows?
Dec
9
answered Excel counta function fixed reach
Dec
9
comment Excel Using Reference for Worksheet names
note also that it will expect the full name - workbook would not work, you would have to put workbook.xlsx - If the file is closed, you would need the full pathname: C:\Users\MyName\Documents\workbook.xlsx
Dec
9
answered using functions in COUNTIF criteria
Dec
9
comment How to skip empty cells while counting instances of days-of-the-week
Weekday returns #VALUE! if there is text in the range (and it will return #NUM! if there is a number that cannot be a date, i.e. outside the range 0-2,958,465)
Dec
9
answered Finding a number in a range
Dec
9
revised What functions can I use to track subscriptions?
added picture inline
Dec
6
comment What are these “notches” on the side of the PCI Express connector?
@jnovacho, looks like it could be this motherboard, but only OP would know for sure
Oct
30
answered Excel 2010 VBA on-start macro execution - Error
Oct
30
comment Microsoft Excel 2010 subtraction results in wrong answer
stackoverflow.com/tags/rounding-error/info
Oct
30
comment Excel 2010 crashes: Excel.exe 0xc0000005 when trying to highlight from pivot table
stackoverflow.com/questions/16742454/… may give you some ideas
Oct
28
comment excel sql server error: Invalid object name
@FrankThomas, added code. I do not have access to view or edit the function itself, but I added the code and connection information
Oct
28
revised excel sql server error: Invalid object name
added code from actual function
Oct
24
comment excel sql server error: Invalid object name
the function works correctly in SQL Server, but if I put it into an excel data connection, I get the error. The manipulation is actually taking a time field, and rounding down to the nearest half hour
Oct
24
comment excel sql server error: Invalid object name
@FrankThomas, can I set no count from an excel data connection? The naming of the column is only for readability, but removing it has no effect on the response from excel
Oct
24
asked excel sql server error: Invalid object name
Oct
8
revised Can I delete empty recovery partition (Win8)
added picture inline, instead of external link
Oct
8
revised Old MsWord file opening with junk characters
removed spam tag
Oct
1
comment Link Excel workbooks so that I can use them on another computer (Excel 2011 for Mac)
excel stores relative links only when the path is on the same drive. see this for further info