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~
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...
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...
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...
Hi Chandoo,
Congratulations on the new Twins!
I need a formula or method to pull out some very specific text from a cell.
Here's an example:
[9/25: 12345678 1234ABCD This is a test to see if I can find a better way.]
I just want to pull out the 12345678 and the 1234ABCD into their own...
I don't use it every day, but am familiar with it since using it for some empirical research projects I've worked on.
I hope IBM makes SPSS more user friendly though. I personlly think that if they put some of the name and range functions of lotus 123 into SPSS, they'd be able to compete with...
The type of tail you're measuring your stat result against depends on what you're trying to find out.
So if you want to perform a statistical test to see if something is equivalent or not, then you refer to the Two Tailed number.
Alternatively if you want to test to see if something is...