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!

Search results for query: *

  • Users: gizmo1973
  • Content: Threads
  • Order by date
  1. gizmo1973

    Remove XLS duplicates but leave a fixed amount instead of just one

    Okay, we all know in XLS you can easily remove duplicates by sorting and using the IF statement and in XLSX they've even added a little tool for us to do this but herein is my dilemma… Both these operations assume I only want to be left with a clean list of data i.e. only one record from the...
  2. gizmo1973

    Increse number on Print

    Hi all, Quick on for you; I'm sure I have seen this before but I cannot find it. In Excel 2003 I have a cell which says MMS/000001 and what I am after is for this cell to increase by one every time the sheet is printed. ie MMS/000001 MMS/000002 MMS/000003 So on and so forth, I was going to...
  3. gizmo1973

    Greatest Date

    I have a query that produces a list of dates for a specific event, the company has now decided that they will repeat the event until they get a satisfactory conclusion... So I need to be able to only show the last event by the date entered and that's where I am stuck, I have tried to convert to...
  4. gizmo1973

    Destination box in Excel

    I know what you are all going to say "use access" but in this instance I can't as it's for a friend who works for a charity and they cannot afford Access. Okay we have an XP excel workbook with over 300 sheets and I need a navigation aid from the Master sheet, ideally a text field go button...
  5. gizmo1973

    trying to networkdesktop and laptop

    Apologies if this is the wring forum, re direction would be appreciated. I am trying to network my laptop with my desktop but i cannot get them to appear on the same network via wizard so i tried a direct connect approach, the laptop worked fine as a Guest set up in the new connection wizard...
  6. gizmo1973

    Missing CD/R

    Hi, a friend has just brought his laptop over as his CD/R drive is no longer showing on the explorer. I have checked in the hardware device manager and it is showing the yellow exclamation and the error code is 19 saying that the system registry is at fault. i have searched here and on MS...
  7. gizmo1973

    System Using Upto 99% of CPU time

    Hi guys, I have posted this in the XP Forum here thread779-1167900 but wanted to check that I am not missing anything, the advice I have received seems to have worked but has anyone heard of this in a specific instance? Original Thread Text Don't know whether this should be happening but when...
  8. gizmo1973

    System using upto 99% of CPU

    Don't know whether this should be happening but when I check in the windows task manager processes I constantly see this Image Name of System User name of SYSTEM using up-to 99% of my CPU (even the system idle is not getting a look in) This is causing major lock ups and hangs on all other...
  9. gizmo1973

    Cannot delete item, in use when it is not

    I have a Video clip that is stored on my C drive and when i try to delete it I keep getting the error message Cannot delete "FILE NAME" : it is being used by another person or program Close any programs that might be using the file and try again I have closed everything I can think of and I...
  10. gizmo1973

    Ultimate Pop Up Killer

    downloaded thislast night as a recommend from a friend via C Net but since then my homepage has been hi jacked by www.searchby.net and hijackthis is blocked by the little so and so!!!!! Anyone heard any nasties about this app? Anyone recommend a good, free pop up stopper??? Only other changes...
  11. gizmo1973

    MS Excel - Password Protect with a criteria

    Hi, Is it possible to protect an excel workbook with a password after a certain time frame has passed. i.e. The workbook is created and is not protected then after 14 days a password is required to open the workbook in future? Or if is this is not possible is there a way to get the contents of...
  12. gizmo1973

    3 Versions of XP

    My fault entirely that I have 3 version of XP Pro on my machine. One "good" version which I use and want to keep. One "Bad" version which was another full install to replace the "good" version when it was corrupt (now fixed) One "set up" version which will not complete or abort (just says the...
  13. gizmo1973

    Internet Explorer error message

    Help!!! seen this in this forum for Excel and Word but not I.E. I keep getting the below when accessing a certain site on my home P.C. (other P.Cs can access it fine) Tried some of the other solutions but they don;t seem to work and it's only limted to this one site!!!! The instruction at...
  14. gizmo1973

    Internet Explorer error message

    Help!!! seen this in this forum for Excel and Word but not I.E. I keep getting the below when accessing a certain site on my home P.C. (other P.Cs can access it fine) Tried some of the other solutions but they don;t seem to work and it's only limted to this one site!!!! The instruction at...
  15. gizmo1973

    Wallpaper at Log On and Lock Up

    I have seen this before but cannot find it on the search. I have a user who has a default wallpaper on when he is working but at log on or when he locks the machine (ctrl alt delete and K) he sees a totally different wallpaper. We wish to remove this second wallpaper and I'm sure there is an...
  16. gizmo1973

    Turn six digits into date

    Hi, I have data like this 210305 220405 190504 210704 Which I cannot format as date! How can I siwtch these from a number into a date? i.e. 21/03/05 22/04/05 19/05/04 21/07/04 Regards, Phil. M.U.F.C. Show your true support here, it's still not too late...
  17. gizmo1973

    If Or statement

    I'm having a brain freeze here and can't remember how to do this, help and searching on here provides no help (key words probably too small)... here goes. I need a formula that goes like this =IF($E$1>G82,"Feedback Required"," ")I have this bit already but also if G82 is blank/null I want " "...
  18. gizmo1973

    Good thinking Batman

    Where did this phrase come from? Obviously the series/film Batman but I don't seem to remember this is a catchphrase as such, not like "gee willickers" etc I have noticed a lot of my age group (30 something’s) use this phrase when a good idea is formulated. Are my colleagues and I the only ones...
  19. gizmo1973

    HJT Log

    Please see thread760-1022522 for the problems that have been going on.... Logfile of HijackThis v1.98.2 Scan saved at 12:51:47, on Wednesday 16/March/2005 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes...
  20. gizmo1973

    I keep being clobbered by SASSER

    But all removal tools say I'm not infected. I have tried the SOPHOS removal tool, PANDA AVG and Microsofts patches. Is this a new version or am I missing something? Regards, Phil. M.U.F.C. Show your true support here: http://shareholdersunited.org/join.php?ref=125059000 "Shares not Shirts

Part and Inventory Search

Back
Top