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!

Register Log in
  • 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!

Search results for query: *

  • Users: herkiefan
  • Content: Threads
  • Order by date
  1. herkiefan

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

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

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

    Excel 2007 Paste Special &gt; 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...
  5. herkiefan

    Excel 2007 Paste Special &gt; 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...
  6. herkiefan

    Excel 2003: IF/THEN or MIN formula

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

    Pie Chart order of Data

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

    Excel: CONCATENATE vs. multiple &amp;'s

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

    Quick comma question

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

    Dates in Charts

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

    Excel 2003 SP2: Close a file that someone else has 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...
  12. herkiefan

    Excel 2003 SP2: How do I close a file that is opened by someone else?

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

    Excel 2003: Print Area macro does not work

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

    Enable Outlining with a protected worksheet.

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

    Excel 2003 Calculate in the Status Bar

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

    Vlookup with IF(ISERROR... or is there a better way?

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

    Office 2007 compatibility with other versions

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

    Excel cannot complete this task with available resources.

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

    Subtotals with Sum and Count

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

    WMD or WMD's?

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

Part and Inventory Search

Back
Top