Reputation
525
Top tag
Next privilege 1,000 Rep.
See vote count; VIP usercard
Badges
2 8 28
Impact
~84k people reached

Jul
25
comment PivotTable — how to sum the result of a countif formula by group?
The pivot table shows the sum of each type of license per group. I'd essentially like the following additional fields: full license cost (pivot sum * B16), full license maintenance (PT sum * B19), limited license cost (pt sum * B17), and limited license maintenance (pt sum * B20)
Jul
25
revised PivotTable — how to sum the result of a countif formula by group?
Added a link to the file in question
Jul
25
asked PivotTable — how to sum the result of a countif formula by group?
Apr
1
awarded  Popular Question
Feb
9
awarded  Popular Question
Feb
8
awarded  Notable Question
Jan
10
accepted SATA 6Gb/s vs. 3Gb/s when using SSD Caching via Intel RST?
Jan
10
asked SATA 6Gb/s vs. 3Gb/s when using SSD Caching via Intel RST?
Nov
18
awarded  Self-Learner
Nov
15
awarded  Popular Question
Nov
9
accepted Windows 7 install issues with 2x3TB in RAID1
Nov
5
answered Windows 7 install issues with 2x3TB in RAID1
Nov
4
revised Windows 7 install issues with 2x3TB in RAID1
corrected minor spelling (UEFI instead of EUFI).
Nov
4
revised Windows 7 install issues with 2x3TB in RAID1
formatting.
Nov
4
comment Windows 7 install issues with 2x3TB in RAID1
So It sounds like what you're saying is that the drives are partitioned with MBR by default? Win7 setup with bare disks is what led to this. I'm looking into how to use diskpart to achieve the desired partitioning.. Regarding AHCI mode vs. RAID mode: I have the Intel controllers set to RAID mode and the Marvel controller set to AHCI. I've since unplugged the SSD to remove it from the equation.
Nov
4
comment Windows 7 install issues with 2x3TB in RAID1
so since I've updated the Asus P8Z68-V/Pro Gen3 mobo to the latest firmware, this should include the updated driver for the Intel Z68 chipset's native RAID1 support? I've updated the firmware but while the BIOS sees it correctly, windows does not. It seems I need to partition the drives using GPT -- looking into whether that would solve the problem. Was curious as to whether additional drivers at Win7 install startup would have solved it. Can't find any sort of download for this scenario..
Nov
4
suggested approved edit on Windows 7 install issues with 2x3TB in RAID1
Nov
4
comment Windows 7 install issues with 2x3TB in RAID1
Hi Andrew, while you're wrong about my approach (I plan on installing Win7 to the RAID1 array and accelerating that using Intel RST and 64 GB partition on the SSD) -- loading the correct drivers for the controllers seems to be the correct way to go. I guess I have to find the mass-storage drivers first. Any pointers on this would be very helpful. Thanks!
Nov
4
comment Windows 7 install issues with 2x3TB in RAID1
Hi Hennes -- is there a way to partition with GPT from within a UEFI bios? I want Windows to be installed on the 3TB RAID1 (planning to use the SSD as an accelerator for the RAID1 pair). Sounds like if I can get them properly formatted & partitioned using GPT I'd be ok?
Nov
4
asked Windows 7 install issues with 2x3TB in RAID1