450 reputation
1518
bio website
location Oregon
age 26
visits member for 4 years
seen Nov 14 at 19:14

I barely know anything about everything.


Apr
30
comment Install windows 7 on mac without product key
@AlexYan It is an Air, so no DVD drive.
May
20
comment Can you edit the contents of an Excel cell without having to double click it?
@DavidGard no problem. I also updated my answer with a third alternative which may work for you.
May
20
comment Can you edit the contents of an Excel cell without having to double click it?
Are you sure there is no script or function that can do this "cleanse" for you? When faced with a similar situation, I took all the data from excel and successfully ran it through a small regex script.
May
15
comment USB File Transfer Log
With respect to your comment on cloud storage: from a security point of view, if you encrypted your flash drive it would be a lot more secure than anything sent into "the cloud."
Apr
8
comment Password manager for multiple computers?
In addition to password recall, you also have several other issues that prevent this from being a 100% solution. For instance, sites that have specific password requirements (symbol, upper-case, max-length, etc.) would all break this approach. Then you would have to remember which sites you hashed and which sites you had to set different passwords to, in addition to everything you already have to remember (password, hash key, site name, etc.).
Apr
4
comment Links from Localhost not working
Are you receiving 404 pages, or is the URL actually a hash href="#"?
Apr
1
comment Laptop that only boots after being placed in the freezer once all power is depleted?
Not criticizing your idea, just wondering how you get to the point where you think, "Hmm, the laptop's not working, I think I'll put it in the freezer for a few hours."
Apr
1
comment Find last row in sorted table for matched value
Disregard that. I was able to workaround this issue by making the initial cell an array function, then dragging the array function down to fill in the remaining table rows.
Apr
1
comment Find last row in sorted table for matched value
This partially works. If I make each individual cell an array, then it pulls the correct date. If I don't and instead make the entire table an array, then it only uses the first order number (A13) as the comparison. How can I make this a true array function so I don't need to manually set each row as an array? I tried =MAX(IF(A1:A6=A13:A14,B1:B6,"")) but that returns #N/A. Why is the array function not correctly pulling the partial-sample order#?
Feb
1
comment Microsoft mail merge incorrectly formatting numbers
This worked. The text formula is not necessary, though, as it turned out I simply needed to change the cell format from number to text.
Jan
8
comment Interpreting PHP offline?
@tkbx if you install a server on your home computer you won't have to deal with FTP or uploading at all. At that point it is just a drag and drop on the local filesystem.
Jan
7
comment Coloring partial text within cell in Excel
@chuff Yes, I was building them up as strings so I could get around the grid limitations of Excel (fixed width column size for each row).
Oct
6
comment Excel quartile function doesn't work
Excel returns both 5.5 and 6.5; the former is the exclusive quartile calculation, the latter is the inclusive quartile calculation. I have absolutely no idea what the difference between them is :P
Dec
22
comment What options are there for generating custom text snippets on the Mac?
Thanks for the heads up. I'll look more into what options my IDE has for snippets and macros. This is exactly the info I was looking for!