Arjan

Netherlands

8h
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
9h
answered How to split numbers into columns with negative and positive values, without empty cells?
10h
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. :-)
10h
revised IF formula where the test is a logical value in OpenOffice
The semicolon is not a regional setting
11h
comment How do I test if a cell in OpenOffice Calc contains #N/A?
...but this is not available in OpenOffice.
2d
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.)
2d
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.
2d
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
8
awarded Famous Question
Dec
6
revised How to generate the appID for a Google Chrome Extension
Copied relevant code from archive.org; replaced dead link
Dec
6
revised REST authentication and exposing the API key
Fixed outdated links.
Dec
6
reviewed Approve suggested edit on Sending file via netcat
Dec
5
awarded Nice Answer
Nov
29
comment Trace an installation on a Mac OS X
possible duplicate of How can I track the changes an installer makes?
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.
1 2 3 4 5