Recent content by mdrollas

  1. 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...
  2. M

    VB for Excel Please help!!

    Thanks for all the guidance! Will give each option a try.
  3. 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...
  4. M

    Excel Question - How to remove external links

    Problem solved, thanks!
  5. 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!
  6. 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)...
  7. M

    Another new build problem

    thanks! It WAS the video card :)
  8. 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,
  9. 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.
  10. 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!
  11. 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.
  12. 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!
  13. 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
  14. 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!
  15. M

    Newb OC question

    I have Asus A8N5X, I have 2 ide hard drives and I dont' know if they are locked. thank you