Recent content by eggohead

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