Search results for query: *

Thanks Skip, works like a charm now. “Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.”-Albert Einstein

Values from my age range column: Age Range <= 29 30 to 34 35 to 39 40 to 44 45 to 49 50 to 54 55 to 59 60 to 64 65 to 69 70+ Unknown “Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.”-Albert Einstein

I apologize for not posting my formulas. Age Range = $BY$6:$BY$15000 Criteria = CK6 the label contained is "<=29". Formula and Result: =COUNTIF($BY$6:$BY$15000,CK6)= 0 =COUNTIF($BY$6:$BY$15000,"<=29")= 0 =SUM(IF($BY$6:$BY$15000=CK6,1,0)) = 1,756 (correct) I was also able to modify your...

Hi, I am having trouble using the CountIf function when the range I reference contains lables that begin with <= and >=. I recieve a large amount of data that has a column called "age range". The lowest range is <=29 and the highest range is >= 70. I do not have the underlying age that...

John- You are so awesome! I've searched every where on the web and within Excel to find this. Thank you. Thank you. “Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.”-Albert Einstein

that is the debate. Which is correct? The new $90-million casino will be within our 60-mile radius. or The new $90 million casino will be within our 60-mile radius. or The new $90 million casino will be within our 60 mile radius. I'm fairly certain that "60-mile" is correct, but I'm not...

Hello gurus! How would I do the following action from Excel 2003 in Excel 2007? Click on the chart right-click select properties select protection click on "move but don't size" (or something similar to that). I use the outline/grouping function when charting and in 2007 I can not find a way...

Please ignore my question. I figured it out. It had to do with going from a 2003 file to a 2007 file. I fixed it by making everything 2007. “Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.”-Albert Einstein

Please ignore this question. I figured it out. “Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.”-Albert Einstein

This is the exact problem: I have a worksheet that has hidden columns, and grouped rows. When I copy an entire worksheet then paste special > formats in to a new workbook, the hidden columns are shown, the grouped rows are no longer grouped, and the column widths are not the same width as the...

So I get back from vacation and on my monitor is a sticky note saying "You system has been upgraded to Office 2007. Please call if you have any questions." Ya, I have questions but the PC Support specialist certainly can't answer them. That's why I come to the gurus here. I have a macro that...

How about =IF(B1=B2,"Alert Alert these values are equal","Do not worry these values are not equal") “Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.”-Albert Einstein

So I get back from vacation and on my monitor is a sticky note saying "You system has been upgraded to Office 2007. Please call if you have any questions." Ya, I have questions but the PC Support specialist certainly can't answer them. That's why I come to the gurus here. I have a macro that...

That's freakin' sweet! Thanks Bluedragon2. “Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.”-Albert Einstein

ID Daily Monthly SEGMENT 1 A A A 2 A A A 4 C A A 9 B C B 10 C D C 11 A D A 12 B B B In the above data, the resulting "SEGMENT" in column D would always be the highest letter. “Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.”-Albert Einstein

Hi gurus. Is there a function similar to MIN that would work with letters? We segment our customers on both their Average Daily Spend and their Average Monthly Spend. What I need to do is take the highest segmentation between the two. The highest starts with A and goes through J. Example...

I use Excel for EVERYTHING. Even when its not the right tool for the job. Mainly because I loathe Word, Powerpoint, and some of the other MS products. “Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.”-Albert Einstein

Hi experts, My new boss maybe the most annoying person I've ever worked with. He nit-picks about the stupidest (IMHO) things. Is it possible to change the order in which a pie chart reports information, without changing the order of the source data? As an Example: A 20% B 40% C 10% D 30%...

Thank you all for your feedback. I'm doing a brief training for a collegue and was wondering if there was a neccesary distinction to make. Guess not. Whatever works. “Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.”-Albert Einstein

Hi, Expert Opinions needed. Is there any reason why someone would use CONCATENATE to merge cells vs. multiple &'s? Quick Example: A B C 1 Michael Q Franklin =CONCATENATE(A1," ",B1," ",C1) vs. =A1&" "&B1&" "&C1 They both equal Michael Q Franklin, so...