Reputation
1,053
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
5 9
Newest
 Scholar
Impact
~89k people reached

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
Sep
20
comment Generate a comma-separated list of cell contents, excluding blanks
@iszi, just how many blank cells are you dealing with? The nesting is only required if you want to handle a lot. If you don't want nested anything, you're going to need a user-defined formula.
Sep
20
comment Generate a comma-separated list of cell contents, excluding blanks
SUBSTITUTE does replace all matches. 398 (24 * 16 + 14) commas get reduced to 38 commas, 38 (4 * 8 + 6) to 10, 10 (2 * 4 + 2) to 4, 4 (1 * 3 + 1) to 2, and 2 to 1.
Sep
20
answered Generate a comma-separated list of cell contents, excluding blanks
Sep
20
comment How can I sort the lines in a text file, by the length of each line, in Notepad++?
Is the data sensitive? Or could you share it on Dropbox/Google-Drive/etc.? If Notepad++ can open and handle that file, I would imagine that my solution would work, but I'd love to try it out myself.
Sep
19
revised How can I sort the lines in a text file, by the length of each line, in Notepad++?
Added an explanation for how this works as well as sample data.
Sep
19
comment How can I sort the lines in a text file, by the length of each line, in Notepad++?
Sure. I'll add one too now, but feel free to improve it.