Reputation
490
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 8 20
Impact
~91k people reached

  • 0 posts edited
  • 0 helpful flags
  • 30 votes cast
May
20
answered Can you edit the contents of an Excel cell without having to double click it?
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."
May
8
awarded  Organizer
May
6
awarded  Notable Question
Apr
11
answered How to display seconds in the taskbar clock?
Apr
11
revised Variable text field in MS Word pulling value from Controls
Added recently discovered downside to error
Apr
10
answered Variable text field in MS Word pulling value from Controls
Apr
10
asked Variable text field in MS Word pulling value from Controls
Apr
9
accepted Re-using conditional formatting in MS Office (Word/Excel)
Apr
8
asked Re-using conditional formatting in MS Office (Word/Excel)
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
8
awarded  Commentator
Apr
8
awarded  Citizen Patrol
Apr
4
comment Links from Localhost not working
Are you receiving 404 pages, or is the URL actually a hash href="#"?
Apr
4
accepted Find last row in sorted table for matched value
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
awarded  Yearling
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#?