Search results for query: *

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...

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...

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...

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...

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...

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%...

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...

Hi, I've read several posts on TT referring to commas, but I still have a question. Which one is correct? In 2008 we won the championship. In 2008, we won the championship. I really hate starting a sentence like this. However, my boss likes it and I'm not really sure which one is correct...

Hi, I can't remember how to do this and have been searching the site for awhile to no avail. I data collected sporadically, eg, twice a week on varying days of the week. I want to use the actual dates on the x-axis and Excel is not letting me. How do I change the dates to labels? I know its...

I have reached an new high in my "annoyance-level." Is there a way to close a file that someone else has open? I have a workbook that only a few people have access to i.e., been given the password to; and one of them (my boss, of course) consistently opens the file and leaves it open...

I have reached an new high in my "annoyance-level." Is there a way to close a file that someone else has open? I have a workbook that only a few people have access to i.e., been given the password to; and one of them (my boss, of course) consistently opens the file and leaves it open...

Hi all, I have a macro that copies two worksheets and pastes them into a new workbook. Then the macro sets the print area on one of these sheets to print on one page. Then the macro saves and closes the file. It works in the current version, however, it takes (IMHO) far too long to run. I...

Hi, this is a continuation of thread68-1250213: Use Group and Outline in Excel with Protection On, where the VBA code was explained to allow the grouping/ungrouping of outlined columns/cells within a protected worksheet. I have followed (uncorrectly, I guess) the directions given and I am not...

The word "Calculate" has appeared in the status bar in one of my workbooks. I know this usually means that the sheet is set to calculate manually. I have gone to Tools > Options > Calculation and the following toggle switches are on: * Automatic * Update remote references * Save...

Hi everyone. Hopefully an easy one... I am trying to utilize the Vlookup function where some of the lookup values do not exist in the table array. This of course results in #N/A. The values being looked up are then added together. The #N/A's can not be added and thus I have several SUM's...

Hi, I have been tasked with researching the compatibility of Office 2007 (mainly Excel) and earlier versions, primarilly Office 2003. Basically I'd be the only person using Excel 2007 since I am the spreadsheet guy around here and I want to know if it would be worth switching when everyone...

Hi, I store a large amount of data in one workbook (BON DATA) comprised of 3 worksheets (Revenue, Payroll, Rated Play) and reference this data using another workbook (DOR Model). I recently modified my BON DATA workbook by adding a couple of columns to the Revenue worksheet and began...

Hi, Is there an easy way to use Excel's Data/Subtotal function to sum certain columns and count other columns? I've tried the following: 1. Run the subtotal fuction by summing the columns that need to be summed. 2. Run the subtotal function by counting the column that needs to be counted but...

I saw an interesting bumper sticker the other day. "Where are the WMD?" I assume the acronym stands for Weapons of Mass Destruction, yet in our current pop-news culture we are used to seeing the plural form as WMD's not WMD. It sounds wierd to me. My question is this: If an acronym can...