3,776 reputation
114091
bio website security.stackexchange.com
location Florida
age 32
visits member for 3 years, 9 months
seen 18 hours ago

I'm not the droid you're looking for.


Oct
31
comment Google Drive terminates without error on startup
@week If that was the case, one would expect this to be happening more often, and easily findable. For that matter, it should have been caught and patched by now (I've been having this problem for about a week).
Oct
31
asked Google Drive terminates without error on startup
Oct
25
awarded  Popular Question
Oct
24
asked How can I use numeric names in a PowerShell hash table?
Oct
24
awarded  Popular Question
Oct
22
awarded  Popular Question
Oct
21
awarded  Notable Question
Oct
21
awarded  Popular Question
Oct
16
answered How to destroy a CD/DVD rom safely?
Oct
11
asked How to troubleshoot “Automatic update of links has been disabled”
Oct
10
awarded  Popular Question
Oct
4
awarded  Popular Question
Sep
27
comment How do I keep Conditional Formatting formulas and ranges from automatically changing?
I haven't gotten around to implementing it yet, but will probably do so the next time I run across this problem. I'll let you know if there are any issues.
Sep
27
awarded  Popular Question
Sep
22
comment How do I keep Conditional Formatting formulas and ranges from automatically changing?
Though the named range provides a convenient short-hand method of referring to the target cells, couldn't you just use the INDIRECT function on its own?
Sep
22
awarded  Yearling
Sep
20
comment How do I keep Conditional Formatting formulas and ranges from automatically changing?
@JohnBensin That sounds like it's exactly what I was looking for. I'll try to remember that one next time.
Sep
20
comment Generate a comma-separated list of cell contents, excluding blanks
Does the Portuguese version of Excel use semicolons to separate function arguments? It's usually a comma for English.
Sep
20
comment Generate a comma-separated list of cell contents, excluding blanks
The reason I said "avoid nested IFs" was because my initial thought was to do some form of =IF(AND(B2="",C2="",D2=""),A2,IF(AND(C2="",D2=""),CONCATENATE(A2,", ",B2) ... But, since you can nest an IF inside of CONCATENATE, it turns out I only really need one IF statement per cell to be concatenated - still a little less than ideal, as I'd prefer some form of FOR loop or an array function, but it works very nicely. See my comment to @Scott's answer.
Sep
20
comment Generate a comma-separated list of cell contents, excluding blanks
@Dane I'm not trying to avoid "nested anything", but I do want to avoid huge amounts of multi-layered nesting especially when nesting within the same function. The sheet I'm working with right now only has 4 cells that need to be concatenated. The first cell is mandatory - so if that's empty there's something that needs fixing to begin with - but the other three may be filled or blank.