Recent content by ericlind

Hey Chihiro, Thanks a million! This works beautifully. I want you to know that you helped me solve a big problem for a Sheriffs department that serves 430K people. This community of Excel gurus is just awesome. Thank you all! :) Eric~

That looks awesome Chihiro. Let me try it with my larger dataset. :)

Hi All, I’ve got a bit of a challenge on my hands, and wondered if you could help. I have a long (300K rows) list of police responses, where I need to identify the 1st earliest and 2nd earliest OnScene and Enroute date/times out of all units responding for each incident. I’ve included a...

One of the things you might be able to do quickly and inexpensively is use a network drive on your internal network. This is something your network admin should be able to set up quickly for you. The really nice thing about it is that you can actually hyperlink to it, so your users can save...

If it were me I would approach this one of two ways: #1: Pull a list of unique values, and then use CountIF or CountIFS to simply count the number of matches. This is essentially the same as a frequency distribution and just as accurate (and in this case a lot faster). If you have more than...

There's a lot of "depends" here and I don't have enough information to help you draw a conclusion. First things first: Are you trying to see if some set of data is equal to, or different than, another set? If equal, then you need to look at the 2-tail test If different, then you need to...

All fixed. Somehow my automatic calculation was turned off. Thanks for the help!

Thanks Chandoo. =) I'll give this a shot.

I should say it worked fine until about a week ago.

Hey Folks, I reuse a couple of spreadsheets every day; both of which are supplied with new data each day. The problem I'm having now is that Excel isn't updating the results of my calculations. So for example if the first cell in the column is calculated as 123, and I double click the handle...

Might just be easier if you Advanced Filter the column for unique values and use those as your reference points for your frequency formula to calculate against (minus the MAX formula). I also wonder if you're getting no results because MAX was included in your frequency formula. MAX, by...

It should work, but you have to apply the Absolute Value function to both source cells.

If you couldn't tell by my user name, I'm Eric. I work for a global telcom, and am regularly challenged by Excel problems of a whole range and variety. I'm also a six-sigma green belt. I also just completed my B.S. in International Business about 2 years ago (while working full time) and...

I should add something here that you COULD apply the more basic formula to conditional formatting. If you have Excel 2007 then there's a feature that does this automatically within Excel. If you have an earlier version of Excel though, from the left hand drop down, select FORMULA IS, instead...

I'm not sure I know how to solve this particular problem for you or not, but something I've been using to search a cell for specific text is: =ISNUMBER(search(find_text,within_text,[start_num]) In this case I wrote this specific formula: =ISNUMBER(SEARCH("blog",B1)) _ A___ | ____B 1...