Search results

  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!!

    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...
  3. 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)...
  4. 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,
  5. 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!
  6. M

    Newb OC question

    I am following Zebo's Q n' Dirty OC guide. However my FSB(HTT) only tops out at 230ghz. Is it my mobo? I have a Asus A8N5X, Optey 165, Corsair XMS Twinx Ram (ddr400). TIA!
  7. M

    Verizon FIOS Bandwidth limit?

    I am currently using Comcast HSI and lets just say I download around 30-50G/month on average. Though I heard from a friend that Comcast limits the download to only 20g/month, I never had any problem. FIOS just became avaliable in my area and for 2bux/month more, its about 2.5 times faster. I...
  8. M

    A8N5X - sound not working

    Tried installing the lastest AC97 driver and still no sound at all (from the speaker). I then tried to put in a cheapo CMI8738 PCI sound card but whenever the computer crashes whenever I am installing the driver. Is there something wrong with the mobo? This is a new build and I am...
  9. M

    First Self Build, computer won't turn on, please help

    Was so excited to get my first own build yesterday. However, after everything installed, but computer wouldnt turn on. The only thing on was the green led on the mother board. Not even the PS fan. What can be some of the possible problem? thanks!!
  10. M

    Noob question - Flushing OEM Bios?

    Got a compaq MSI OEM mobo. Model# is MSI MS-7184 with ATI RS482 chipset. The OEM bios sucks big time. I am wondering if there is a possiblity to flush it? Thanks!
  11. M

    LCD backlight leakage?

    Hi, I got a Westinghouse 26" LCD TV from BB during the BF sale. I notice there is a backlight leak that is about the size of my thumb nail (the spot is almost white when the whole screen is black. I am wondering if it'll get bigger? Should I get a replacement? thanks
  12. M

    Gateway Laptop screen problem - please help

    I bought a 4025GZ from OD a few month ago. I worked fine until last night. The monitor just wont work. If I use the VGA connector, it works fine. Is it a bad panel/backlight? TIA
  13. M

    Pentium M? Centrino

    Stupid question is Pentium M equal to Centrino? Is yes, why are the sticker differnt?
  14. M

    USB ports stopped working, please help!

    My sister wanted to use a Motorola picture/ringtone software but found out it the software doesn't work with SP2. She then tried to uninstall SP2 and the machine wouldn't boot propoerly (there is a blue screen in start up saying some files are missing and the missing files must be reinstalled)...
  15. M

    How to remove cpu?

    Hi, I am a hardware newbie. Except installing hard drive/ pci/agp cards, I can't do any other hardware installation. My sister has a Dell Dimension 2400 and I want to do a cpu upgrade. Is there any guide online with images? thanks in advance!
  16. M

    Radeon 9000 64mb $30, FX5200 $40 retail Wal-Mart BM YMMV

    Saw it at my local WalMart tonight in Germantown, MD. They were on clearence for $50, and $75. New lowered price. The 9000 is not a bad card for this price. But only AGP 4X though. It has passive cooling, so it would be a great fit if you are building a budget silent rig.
  17. M

    Newegg Refurb SAPPHIRE RADEON 9600XT 104.5 shipped

    128MB DDR, 128-bit, DVI/TV-Out, 8X AGP, BULK (OEM, BAREBONE) LINKY Pretty good price, 25% cheaper than a new one. Base on a review, says this card runs Doom 3 fine
  18. M

    Epson Chip reset software!

    Supported models: Epson Stylus Color 400 Epson Stylus Color 440 Epson Stylus Color 480 LPT Epson Stylus Color 480SXU/580 Epson Stylus Color 600 Epson Stylus Color 640 Epson Stylus Color 660 Epson Stylus Color 670 Epson Stylus Color 680/777 Epson Stylus Color 740 Epson Stylus Color...
  19. M

    How to tell the speed of old ram??

    I got 2 sticks of old ram and they are either PC133 or PC100, how can I tell the speed? thanks
  20. M

    IDE channel problem

    Hi, Just installed a burner for my parent's computer and found the transfer mode is at PIO mode. Any way to change it to UDMA mode? thanks It's a P4 2.8 running winxp pro
  21. M

    Copying entire HD to a new HD with Norton Ghost??

    Hi: I just got a new 160G HD and want to use it as the main drive and put the old 60G as my 2nd HD. Is it possible to use Ghost to copy the entire HD (including programes, window xp) and it will fuction fully? how do I restore the Ghost image file afterwards? thanks a million!
  22. M

    Warm? ADATA 512MB DDR 400 PC3200 RAM at NewEgg $70!

    Not as hot as last week's Kingston for $60, but no rebate hassel and decent review. Should be able to run dual channel. Link
  23. M

    Passive cooling video card

    Hi, I am looking for a budget passive cooling video card to build a quiet system. Planning to spend around 50-55 dollars. This system is for my parents and they won't do any gaming. Maybe watch some DVD, MPG that's it. Basically 2D stuff. Is 9200SE (around 48-52) good enough or should I get...
  24. M

    Chicken and Egg debate

    I was chatting with my friend and touched this topic. From the dawn of time, was there chicken first or egg first? I'd say chicken :D
  25. M

    Air conditioning unit broken, looking for advice plz help!!

    Hi, I live in the D.C Metro area. Moved into my new place last Sep. My townhouse has 3 levels, ground, 1st and 2nd level. Last week it started to get hot and I notice the AC is only working on the 2nd level, but not the ground and 1st level. I was told my house uses 2 AC units. I went out and...