798 reputation
37
bio website
location Front Royal, VA
age 33
visits member for 4 years
seen Jul 25 at 16:34

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.
Sep
18
comment How can I sort the lines in a text file, by the length of each line, in Notepad++?
@barlop I'll see if I can do a little diagnosis on the N++ macro. The result from my simple attempt was terribly corrupted results with many unusual and non-printing characters added. Also, while I was inspired by the YouTube video, my steps are a bit different.
Sep
16
comment How can I sort the lines in a text file, by the length of each line, in Notepad++?
The answer has been updated to retain the existing sort order, assuming that is important.
Sep
16
revised How can I sort the lines in a text file, by the length of each line, in Notepad++?
added 703 characters in body