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

Mar
2
comment Can't compare a cell to a column in excel
What's your formula? Perhaps post the formula in your question. Why doesn't vlookup() with a final parameter of FALSE work for you?
Feb
27
comment Word 2010 - What is the unknown character displayed as a number?
Seeing the symbol here would definitely be helpful. There's a decent chance that the mystery updater has a font that you do not. Any chance these mangled words were being given special formatting?
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.