963 reputation
47
bio website
location Front Royal, VA
age 33
visits member for 4 years, 4 months
seen 5 hours ago

Feb
26
comment How to sort this list in excel?
That's a useful pattern for many situations where you are taking data that is formatted for reading and want to make it a sortable/filterable table. "Paste Values" is a key feature to know in Excel.
Feb
25
revised Can't compare a cell to a column in excel
added 109 characters in body
Feb
25
answered Can't compare a cell to a column in excel
Feb
14
answered What are these strange characters?
Jan
28
awarded  Yearling
Jan
27
answered Define value of a column by another column in Excel
Dec
23
comment Problems opening sharepoint document, checked out, but opening from temp folder instead
@LasseV.Karlsen, did you get this figured out?
Nov
26
comment Writing a Simple AutoHotkey Script (press a key every X second on desktop)
Is this to keep a remote desktop session open?
Oct
16
comment Is there an Excel formula to identify special characters in a cell?
I do want to point out that you're probably using the wrong tool for this. I can think of a couple ways of doing this pretty quickly in Notepad++, for example. You could even import the results into Excel at the end and have a column of 1s and 0s.
Sep
27
comment How to open huge PNG image
This is getting further afield, but you could convert it to a tif: libpng.org/pub/png/apps/ptot.html
Sep
27
comment How do I make Excel recognise TRUE or FALSE text as boolean values?
@Abbie What are you copying from? Copying "TRUE" and "FALSE" from a plain text file into Excel 2010 works with =INT(), even though it's formatted as General.
Sep
27
answered How to open huge PNG image
Sep
27
comment Calculating difference between 2 times, excluding weekends, then averaging the results
@Jill, barry houdini's new "Alternative Solution" will correct for the odd behavior of =NETWORKDAYS(). You really probably need to do two columns, one using the pretty format that includes the text, and another that just has a simple time value in it. Use the simple time value for your average.
Sep
27
comment Calculating difference between 2 times, excluding weekends, then averaging the results
@Jill, to see what's wrong with your existing formula, put in 9/26/13 11:00pm and 9/27/2013 01:am. You should get 0 days and 2 hours, but instead you get 1 day and 2 hours, because =NETWORKDAYS() counts any portion of a workday as a full day.
Sep
26
comment Excel formula to split a cell and reverses the order
This is kinda brilliant. It took me a bit to parse it. Any chance you'd explain what you're doing?
Sep
26
comment Excel formula to split a cell and reverses the order
Creating a module is the secret step everyone needs to know about.
Sep
26
answered Excel formula to split a cell and reverses the order
Sep
26
comment Excel formula to split a cell and reverses the order
Why are you avoiding macros? This can be cleanly solved with a small User-Defined Function.
Sep
24
comment How can I sort the lines in a text file, by the length of each line, in Notepad++?
Hey @HPM, any chance of getting to work on your data?
Sep
23
answered Comparing 2 columns to result in a count total