19,005 reputation
84788
bio website
location Netherlands
age
visits member for 5 years, 5 months
seen 10 hours ago

1d
revised How to split numbers into columns with negative and positive values, without empty cells?
Minor fix for the if(iserror())
Dec
17
revised How to split numbers into columns with negative and positive values, without empty cells?
Ah, no range needed in row(...) as it's the same as the result row
Dec
17
answered How to split numbers into columns with negative and positive values, without empty cells?
Dec
17
comment IF formula where the test is a logical value in OpenOffice
@fixer, thanks for the edit and just FYI: I just discovered that the ; is not a regional difference. :-)
Dec
17
revised IF formula where the test is a logical value in OpenOffice
The semicolon is not a regional setting
Dec
17
comment How do I test if a cell in OpenOffice Calc contains #N/A?
...but this is not available in OpenOffice.
Dec
15
comment How to split numbers into columns with negative and positive values, without empty cells?
Microsoft's explanation works fine for me, klausnrooster and @user. In OpenOffice I get this when using the following array formula (note: save with Ctrl+Shift+Enter or Command+Shift+Enter, or something similar) in cell B2: =index($A$2:$A$8; small( if($A$2:$A$8 >= 0; row($A$2:$A$8); ""); row($A$2:$A$8) - 1 ) - 1) And the same with < instead of >= in cell C2. (Note that my OpenOffice uses ; between function parameters, while Excel might want , there.)
Dec
15
comment How to split numbers into columns with negative and positive values, without empty cells?
Now that this question is locked: as one knows the row number for the result column, see Microsoft's Excel: Finding the nth Value That Meets a Condition for a non-VBA solution.
Dec
15
revised How to split numbers into columns with negative and positive values, without empty cells?
Copied some more from the original question
Dec
14
revised How to split numbers into columns with negative and positive values, without empty cells?
Reworded. Removed noise.
Dec
14
comment windows 7 how do I search for files and exclude subfolders?
For future readers: it seems that System.FileName can also match directory names, so then maybe System.FileName<>name_of_subfolder would work. Also, System.Kind might allow for System.Kind:<>folder to exclude all folders (or when combined with System.FileName specific folders?). And it seems one might use this long list in search. (But: I am not using Windows.)
Dec
14
comment windows 7 how do I search for files and exclude subfolders?
@NiteCyper, did it work for you in Windows 7? (I am not on Windows, but it seems the parameter is outdated? See the links I added to the answer.)
Dec
14
revised windows 7 how do I search for files and exclude subfolders?
Added more recent resources
Dec
14
revised windows 7 how do I search for files and exclude subfolders?
Added link to documentation
Dec
6
reviewed Approve Sending file via netcat
Nov
29
comment How can I sync files from home with files at school?
Bitcasa has changed their business model effectively showing how much they care about their users by giving them only 3 weeks to act, for those who were lucky to even get notified to start with. Big fail; don't trust them with your data.
Nov
29
comment Best tools and strategies for backing up 5+ TB of data?
I'd not recommend Bitcasa. They have recently changed their business model and gave people 3 weeks to act, and even failed to notify me about those changes at all so now I'm locked out.
Nov
29
comment What is best online Archival site not backups for big personal data
Well, Bitcasa changed their business model. I would NOT recommend their services at all anymore (if only as they failed to notify me about their changes, and wiped my data).
Nov
29
comment how to verify TBs of data copied from cloud
Ah, you were lucky to even get such notice. I did not :-( Indeed, NOT recommended. Did you get notified by email?
Nov
29
comment Is a DSL splitter required, if only a Modem is attached to the line?
Indeed, my provider (XS4ALL, The Netherlands, FRITZ!Box 7360) explicitly asked me to remove the splitter for a situation where only (V)DSL is used, without any analogue telephony. I'm not sure if the type of modem matters.