Search results for query: *

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.

Fen, Your formula worked pretty good - thanks!

Hey Skip good point. In some rows there will be a logon id which can have a number or two. So there would need to be some logic to strip all the text and choose the greatest value from the two columns with the requirement that it has 3 to 4 numeric digits. Sounds kind of complicated. Im just...

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

OK I imagine the formula will be similar to the following one you provided but use another function to average or sum. All of the variables are the same the only difference is its now column M and the function is different. =SUMPRODUCT(--(DATES!L2:L148>=B2)*((DATES!L2:L148<=B3))) Column M...

Skip, I dont need to count. I need to average the values that fall between B2 and B3. Or I guess I could sum those values then divide by the fomula I listed.

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

Skip, I must be smoking something. There was eleven values. Just didnt sort the whole list. Thanks I also corrected the sign as you mentioned so Im good. =SUMPRODUCT(--(DATES!L2:L148>=B2)*((DATES!L2:L148<=B3))) Thanks again,

Thanks Skip! so here is the formula: =SUMPRODUCT(--(DATES!L2:L148>=B2)*((DATES!L2:L148>=B3))) The only problem is this returns a value of 136? Theare are 147 rows so that would mean it finds 11 values. There are only 5 values that meet this criteris in this columen so it should return 5...

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