Reputation
Top tag
Next privilege 250 Rep.
View close votes
Badges
1 3 16
Impact
~51k people reached

Mar
30
awarded  Popular Question
Feb
1
comment Count number of cells that match certain criteria with formulae
The forum provided a solution to the problem: =SUMPRODUCT((A1:A20<>"")*(MONTH(A1:A20)=12)).
Feb
1
comment Count number of cells that match certain criteria with formulae
I have found a side effect on Google Spreadsheets. =SUMPRODUCT(1*(MONTH(A1:A20)=12)) counts also empty cells.
Jan
22
comment Count number of cells that match certain criteria with formulae
Thanks. Works on OO v4.1.2.
Jan
22
accepted Count number of cells that match certain criteria with formulae
Jan
22
comment Count number of cells that match certain criteria with formulae
@DavidPostill: The formulae I gave does not produce the correct result.
Jan
15
comment using btrfs features to rapidly and efficiently combine large files
cp --reflink works fine on btrfs (see here), but it serves a bit different purpose. Of course if you know in advance that the data is the same, then use it. But btrfs (or better say, a special utility) can run the de-duplication process post-factum (see btrfs wiki). I've never used that utility, however I can imagine it will take a while to find duplicate blocks across whole filesystem.
Oct
18
comment How to disable the “Get Windows 10” icon shown in the notification area (tray)?
See also How to get rid of the 'Your upgrade to Windows 10 is ready' lock.
Oct
17
comment Make Windows bootable after copying from one partition to another
That's the point – I don't have recovery disk. What you say means that I cannot recover without bootrec /rebuildbcd or so. Finally after days of trying I gave up and let Windows leave on 3rd partition (/dev/sda3 in my example), however I was able to copy bcdboot from hidden partition to that one. The space in the beginning of drive I have allocated for drive D:. If you can explain why I couldn't boot from first partition (/dev/sda1) I will appreciate. Nevertheless as a last resort I have used the restore function. It has created the hidden partition again, however boot has failed.
Oct
14
comment BTRFS, Files on a single drive in array but keep 2-parity?
I think in general case that is impossible to manage. For example, you decide to put one 3GB file on your 2GB+2GB volume. Theoretically that should be possible, but in your case btrfs should report an error once you reach 2GB limit (the maximum that your single drive). The tweak becomes more difficult if you have underlying drives (devices) of different sizes. So, no way :(
Oct
14
comment using btrfs features to rapidly and efficiently combine large files
btrfs is a filesystem, not a tool to combine files. Or you mean that you have three files, and on the top of them you want to create a filesystem?
Oct
9
revised Make Windows bootable after copying from one partition to another
added 157 characters in body
Oct
9
revised Make Windows bootable after copying from one partition to another
added 248 characters in body
Oct
8
revised Make Windows bootable after copying from one partition to another
briefly explain your changes (corrected spelling, fixed grammar, improved formatting)
Oct
4
comment Where can I download “bootrec.exe”?
Are you sure that bootrec.exe is inside ISO? I have have browsed original Windows7 ISO content and found no bootrec.exe. There is only boot\bootsect.exe.
Oct
2
revised Make Windows bootable after copying from one partition to another
added 92 characters in body
Oct
2
comment Make Windows bootable after copying from one partition to another
I did bcdboot d:\windows /s d: and bootsect /nt60 d: /mbr as you suggested (also I have updated the question with some extra information, namely with bcdedit output). I still get Bootmgr is missing. I think that is produced by code in boot sector – it cannot access Windows registry. Any further advice is welcomed.
Oct
2
revised Make Windows bootable after copying from one partition to another
added 2343 characters in body
Oct
2
comment Make Windows bootable after copying from one partition to another
I am not using Windows/Linux dual boot. I have only Windows.
Sep
29
asked Make Windows bootable after copying from one partition to another