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 Chriss Miller 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 KenWright

  1. KenWright

    WinXP Activated but can't logon

    Created other admin accounts but it will not let me log on to any of them other than in safe mode, and when i try to activate in safe mode it tells me that you cannot activate in safe mode. Will try calling MS tomorrow. Regards Ken...
  2. KenWright

    WinXP Activated but can't logon

    Same issue. Tried all the steps in http://support.microsoft.com/kb/312295#appliesto but in Step 3: Remove the RESETS registry subkey there was no such key. in Step 7: Replace the corrupted Windows activation file Click Start, click Run, type cmd, and then click OK. At the command prompt...
  3. KenWright

    WinXP Activated but can't logon

    Grrrrrr - just realised that I had an external drive in when I installed, and my primary hard drive letter is now not C, which I want it to be. Am going to do a reformat and install again rather than mess about. Will let you know if i still have the same issue then. Regards...
  4. KenWright

    WinXP Activated but can't logon

    Thanks linney - will give it a go and let you know. Regards Ken.............. ---------------------------------------------------------------------------- [peace]It's easier to beg forgiveness than ask permission[2thumbsup]...
  5. KenWright

    WinXP Activated but can't logon

    Just loaded Win XP Pro from an MSDN disk on to a new drive. WinXP formatted the drive for me and then got all the way through the installation and hit the activation option. Chose to activate and register and it said it was successful, but when I tried to log on it told me I needed to activate...
  6. KenWright

    Lost Product Key Office 2003 after System Recovery

    Assuming you had registered it with Microsoft, then why not give them a call. Regards Ken............ ---------------------------------------------------------------------------- [peace]It's easier to beg forgiveness than ask permission[2thumbsup]...
  7. KenWright

    Pivot Tables in Excel

    If it's a specific field that you are looking at (Assume column B) then you could always just add another column into the source data, and use a formula such as =IF(B2="","HIDE","SHOW"), and then just drag that field into the Page fields and filter on "SHOW" Regards Ken...
  8. KenWright

    Pivot Tables in Excel

    Exactly how I'd do it, but don't forget to refresh the PT anytime you change that date. If you want an example of a formula, then something like the following will do what you want:- Assuming your dates in say Column F and a cell containing your date variable on a tab called "Report" in say...
  9. KenWright

    Merging Data based on Criteria

    Confused - why would you not just use the Pivot table features to exclude the data you don't want. You could also simply add a 3rd column, and use something like =IF(A2=B2,A2,B2) if what you want is one of the two values no matter what, OR, if what you are actually looking for is the sum of...
  10. KenWright

    Allow only numeric entries in Excel

    Just be aware though that DV is easily bypassed by simply pasting in data, as it blows away the DV. Regards Ken.......... ---------------------------------------------------------------------------- [peace]It's easier to beg forgiveness than ask permission[2thumbsup]...
  11. KenWright

    IF(ISNA(VLOOKUP(D2,I:I,1,FALSE)),"DONE", "")..Please save my

    Methinks you need to lay out the whole problem for us, because if we only get a piece of what you are after, you may well find that there was a much better solution available. ---------------------------------------------------------------------------- [peace]It's easier to beg forgiveness...
  12. KenWright

    IF(ISNA(VLOOKUP(D2,I:I,1,FALSE)),"DONE", "")..Please save my

    I think Skips was the right way round and mine was wrong:- =IF(COUNTIF(I:I,D2),"","DONE") ---------------------------------------------------------------------------- [peace]It's easier to beg forgiveness than ask permission[2thumbsup]...
  13. KenWright

    IF(ISNA(VLOOKUP(D2,I:I,1,FALSE)),"DONE", "")..Please save my

    How about:- =IF(COUNTIF(I:I,D2),"DONE","") Regards Ken................ ---------------------------------------------------------------------------- [peace]It's easier to beg forgiveness than ask permission[2thumbsup]...
  14. KenWright

    Random Numbers between 0 and 31 in Excel

    :-) ---------------------------------------------------------------------------- [peace]It's easier to beg forgiveness than ask permission[2thumbsup] ----------------------------------------------------------------------------
  15. KenWright

    Random Numbers between 0 and 31 in Excel

    Then just put in 0 to 31 in order in say A1:A32, in the column next to it use a random number function (in say B1:B32), then select all the data and sort on the random number column. Regards Ken............ ----------------------------------------------------------------------------...
See more

Part and Inventory Search

Back
Top