Hello,
IE8 blocks all isntances of this- I hear the bleep and the window dissappears. Ive tried everything I can think of to get to work. The only thing that works is If I hold down the Cntrl button I can then open this link - very cumbersome. Is there a setting or registry entry that I can...
Hello, trying to create a line graph that illustrates daily freqency from Nov 2009 to Jan 25 2010. The graph partitions the Jan month before Nov and does not follow logica date progression. How can I fix this?
Hello,
Looking for a way to open an exchange mailbox via command line or script(permissions already granted) in outlook 2007. Can this be accomplished?
I basically want to open Outlook and automatically add the box and open it.
- thanks for your help.
Hello,
I have two columns with similar data. In a third column I need to extract the numeric value of the two - whichever column has it. The problem is both columns will have text data in them and are not consistent.
Need to check both columns ignoring any text in both and output the...
Hello,
I have a huge spreadhseet of data that details sites and work orders. I need to list the top 5 worst sites (sites with the mmost work orders). Whats the best way to attack this and what formulas should I use?
I thought using countif to count the occurence of each site number...but...
Hello,
Many Kudos to the folks helping in this forum. I have one more issue revolving around dates. I need to get the average of a column based on a date range.
I used the followiong formula to retrieve a row count of dates that meet date criteria in B2 and B3...
Hello,
Im trying to count a column of dates in one sheet that meet the critera between two date values referenced in cells.
In this case count rows that fall between Nov1st 2008 till the end of the month which whould return 3 in the sample of 10 rows below.
Column:
=Dates!L:L
3/4/09...
Hello, I have a huge list of data that was exported into a spreadsheet. The dates appear to be in text in the following format:
12/11/08 06:37
12/11/08 16:33
12/12/08 09:35
12/12/08 11:45
How can I quickly covert all of these values to dates? If I enter the cell and click enter it gets...
Hello,
I need to crate a performance alert in Windows (XP) that logs an application event for %Process Time over 80% that is sustained for 1 minute or more. How can set a parameter of 1 minute or more?
- Thanks
Hello,
Not sure if I set this up right. I have a table of document paths (just an index field and path Field)which contains the UNC links to documents I have i.e. \\mydoc.doc. I formated the path field as a hyperlink field. I want to be able to click on it and open the document from the...
Hello.
I am trying to run a program with parameters referenced from a list in excel:
row a contains a list of variable parameters
row b contains a static reference to an executable c:\myapp.exe
row c combines the executable and varaiable into a complete command line using &: For example...
I have a list of numbers all in the same column and need to rank the top 5 occurences of the list. How do I do this and what function(s) do I use?.... Rank, Frequency or Count or a combination? Heres what I am looking for - Thanks for your time
rank number occurrence
1 22...
Hello,
I have have an XP pro machine running 2 NICS. The first is connected to a corporate lan and is used for email, file sharing, etc. The second NIC is a wireless adpater connected to a seperate ISP. I want to route web traffic (all web pages I view in IE) through the second NIC and away...
Hello,
I am having some touble using %systemroot% or %windir% in an AT command to schedule a remote software installation. It works fine if use a static maping such as the c:\winnt\sytem32 or d:\winnt\sytem32. I would like to use these variables as some machines have different windows...
Hello,
Is there any way to restrict or grey out the statefull firewall option in the vpn? I have tried modifying the vpnclient.ini file with no luck. Cisco documents how to modify the ini files but there is no metion on how to disable or remove this feature so a user does not have access to...
Hello,
I am using the follwing (from Microsoft KB 189105)to add a printer to a remote machine. This works fine however it takes quite a long time to copy of the driver files to the remtote machine which is on a different subnet. How can I modify the script to use the driver files on the...
Hello,
Our adjacent tenant moved out and left us a Cisco 2980g switch (we are currently using on old Bay networks unmanaged 24 port switch). I have wiped the config on it and set it up to our gateway and it is working good on the status quo. I plan to remove our old Bay network switch and use...
Hello, I have the following view for the 3rd quarter I need to add all 4 quarters in this view each in their respecitive columns. The only thing that will change is the qtr name (ie qt1, qtr2 etc) the sums and the date ranges, the % of target achieved will need to be at the end and calcuate all...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.