Recent content by mdrollas

M
Excel Help Needed..

Greetings! Have an excel and need expertise from Anand gurus! I have the following text in 5 different columns and I am tring to combine them while adding few more characters and things like dash and forward slash. I need to do this for a few thousand lines... so any input would be extremely...
- mdrollas
- Thread
- Mar 31, 2008
- Replies: 2
- Forum: Windows
M
VB for Excel Please help!!

Thanks for all the guidance! Will give each option a try.
- mdrollas
- Post #6
- Mar 30, 2008
- Forum: Programming
M
VB for Excel Please help!!

To all the anand programming wizards. I do not know VB code but is in need of help on data filtering/matching. I have 2 very big excel workbooks with a few thousand lines and am trying to do some filtering/matching. Example below. The two workbooks I have contains same data in column A and...
- mdrollas
- Thread
- Mar 29, 2008
- Replies: 5
- Forum: Programming
M
Excel Question - How to remove external links

Problem solved, thanks!
- mdrollas
- Post #4
- Mar 24, 2008
- Forum: Windows
M
Excel Question - How to remove external links

mayest, thank you for your reply. I tried that and the formula is corrected, however the value becomes 0. I am wondering if its a circular reference error since when I open on this particular excel file it displays a circular reference warning. Thanks!
- mdrollas
- Post #3
- Mar 24, 2008
- Forum: Windows
M
Excel Question - How to remove external links

Hi, I did copy & paste on a few worksheets and noticed that the formulas didnt get copied correctly, instead they now have external links. e.g. [1st workbook]address database'!A20) Instead I am looking for it to reference the same sheet in the current workbook 'address database'!A20)...
- mdrollas
- Thread
- Mar 24, 2008
- Replies: 3
- Forum: Windows
M
Another new build problem

thanks! It WAS the video card :)
- mdrollas
- Post #3
- Aug 20, 2007
- Forum: Computer Building
M
Another new build problem

I just finished assembling all the componets together. However, after I power it up, the built in speaker keeps beeping with a very loud and SHARP noise, also there is no video display. the power, cpu hsf are running for sure. thanks!!! Sonata II case btw,
- mdrollas
- Thread
- Aug 15, 2007
- Replies: 4
- Forum: Computer Building
M
Jumping voltage in cpu-z

I haven't got home yet to look it more. I got this board after a fair amount of research. Even anand wrote up a pretty decent review about it. I just hope its not a faulty board.
- mdrollas
- Post #5
- Oct 15, 2006
- Forum: CPUs and Overclocking
M
Jumping voltage in cpu-z

Recently got a new board (ECS KA1 MVP (1.0) Socket 939 ATI Radeon XPRESS 200 CrossFire) and started to OC. However in CPU-Z the voltage keeps jumping. I set it to 1.4v in bios, but in CPU-Z it jumps around ranging from 1.37-1.42, is it a faulty board? thanks!
- mdrollas
- Thread
- Oct 15, 2006
- Replies: 6
- Forum: CPUs and Overclocking
M
Newb OC question

sorry i didnt mention I dont use clockgen anymore since it always increase my pci bus. I did make all the changes in the bios and still can't get over 233FSB.
- mdrollas
- Post #14
- Oct 9, 2006
- Forum: CPUs and Overclocking
M
Newb OC question

Thank for the reply Gersson, I raised the vcore to 1.425v but still can't get over 233FSB. Even at 233FSB, I can boot but I can't run windows more than 5 minutes without crashing. Is my mobo the problem? thanks!
- mdrollas
- Post #12
- Oct 9, 2006
- Forum: CPUs and Overclocking
M
Newb OC question

I can't seem to lock my PCI. In my bios I see 3 selecton under "pci clock sync mode" 1. is auot, 2. 33.33, 3 sync with cpu. However, even if I choose 33.33, when I try to increase the FSB in clockgen, the pci mhz goes up. TIA
- mdrollas
- Post #10
- Oct 7, 2006
- Forum: CPUs and Overclocking
M
Newb OC question

Hi, I use clockgen to increase the FSB (HTT) and I noticed the PCI is not locked. How can I lock that? Do i do it in the bios? thanks!
- mdrollas
- Post #8
- Oct 7, 2006
- Forum: CPUs and Overclocking
M
Newb OC question

I have Asus A8N5X, I have 2 ide hard drives and I dont' know if they are locked. thank you
- mdrollas
- Post #6
- Oct 6, 2006
- Forum: CPUs and Overclocking

RESOURCES

Top Bottom