Recent content by KenWright

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

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

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

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

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

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]...

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

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

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

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]...

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

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]...

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

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

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