Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ppenn

  1. ppenn

    Check a Column value & sum another Column

    Thanks for all your help. But it isn't what I want to do. I want check colA if there is a duplicate rows, like A3, A4 & A5 are duplicates, so sum B3+B4+b5, then delete Row4 & row 5, only keep Row3, and value of -1.36, I've been trying using something like, the code below it check & delete the...
  2. ppenn

    Check a Column value & sum another Column

    Hi, I have just tried with your fomula, it did not work, I am thinking of using VBA, to check if currentCell value in colA equal the next 1 or maybe 2,3, 4 ect, and then and total colB to appropriate colA, eg. colA3, colA4 & colA5 are the same, so total colB3:colB5 is -1.36. please help. Thanks...
  3. ppenn

    Check a Column value & sum another Column

    Hello, everyone I have a spreadsheet, look like below, I want to check if colA(between rows) value is the same and then sum colB, eg: row 3 to 5 is the same, so sum(b3:b5), put in C3. Any help will be appreciated. col A col B 1 A0202231 -4.73 2 A0202232 135.09 3 A0202238 89.54 4 A0202238...
  4. ppenn

    GetUserName from Network using ASP

    Hi,MrGreed Thank you, it works Regards Pete
  5. ppenn

    GetUserName from Network using ASP

    Hi, everyone I am devloping an application on Intranet using ASP, trying to get the local Network username automatically passing the value(username) into database, thanks in advance. regards Peter
  6. ppenn

    string length in Access table

    Hello Robert Thank you very much - that worked brilliantly - you must be a genius !!!!! Regards Peter
  7. ppenn

    string length in Access table

    I have a table with thousands of records, one of the fields contains figures of varying length (none more than 10 digits) Is it possible for code to search through each record, establish how many digits it has and then add zeros at the beginning to make the original number up to 10 digits. IF...
  8. ppenn

    winlogon.exe and 100% CPU usage

    I experienced this at work with several machines and it was the w32.elkern virus. The removal tool can be found on McAfee or Symantec sites for free.
  9. ppenn

    Old PC - 20Gb disk - Controller Card

    JBOD stands for "Just a Bunch of Disks" I didn't know what it meant but found the meaning a web site. The system will not boot to a floppy even though I set the bios accordingly
  10. ppenn

    Old PC - 20Gb disk - Controller Card

    I am trying to upgrade the hard drive on an old PC - I have fitted a controller card and a 20 Gb disk. The card recognises the hard drive on boot up but then I get the follow on screen "Disk boot failure. Insert system disk". I have amended the startup in bios, but whatever I do I...
See more

Part and Inventory Search

Back
Top