Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by herkiefan
-
Excel 2007 CountIF and SumIF
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- herkiefan
- Post #8
- Forum: Microsoft: Office
-
Excel 2007 CountIF and SumIF
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- herkiefan
- Post #6
- Forum: Microsoft: Office
-
Excel 2007 CountIF and SumIF
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...- herkiefan
- Post #4
- Forum: Microsoft: Office
-
Excel 2007 CountIF and SumIF
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...- herkiefan
- Thread
- Replies: 7
- Forum: Microsoft: Office
-
Excel 2007 Charting
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- herkiefan
- Post #4
- Forum: Microsoft: Office
-
to hypen or not to hyphen...
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...- herkiefan
- Thread
- Replies: 8
- Forum: Making an Impression
-
Excel 2007 Charting
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...- herkiefan
- Thread
- Replies: 4
- Forum: Microsoft: Office
-
Excel 2007 Paste Special > Format
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- herkiefan
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel 2007 Paste Special > Formats
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- herkiefan
- Post #3
- Forum: Microsoft: Office
-
Excel 2007 Paste Special > Format
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...- herkiefan
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel 2007 Paste Special > Format
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...- herkiefan
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel compare 2 cell values
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- herkiefan
- Post #2
- Forum: Microsoft: Office
-
Excel 2007 Paste Special > Formats
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...- herkiefan
- Thread
- Replies: 2
- Forum: Microsoft: Office
-
Excel 2003: IF/THEN or MIN formula
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- herkiefan
- Post #5
- Forum: Microsoft: Office
-
Excel 2003: IF/THEN or MIN formula
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- herkiefan
- Post #3
- Forum: Microsoft: Office
