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 derfloh 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: *

  1. shyam131

    Excel: Changing a cell value with a formula in that cell

    I don't want to use VBA becuase I am distributing a survey in excel via email. Given problems with emails systems and users macro security level setting, distributing the survey with VBA in it will be more trouble than its worth. SP
  2. shyam131

    Excel: Changing a cell value with a formula in that cell

    The reason I cannot put a formula in a cell is because I am trying to change the value of a check box control in execl, if I were to put a formula in the cell the check box is linked to the link to the check box is broken.....I understand that a function returns something, I just want it to...
  3. shyam131

    Excel: Changing a cell value with a formula in that cell

    I want to change the value in a cell in Excel without placing a formula in that cell. For example say I had the Value "True" in cell A1. Now I want a formula in cell A2 that can change the value in cell A1 to "False" if cell C1=3. Does any one have any idea how to accomplish this? I cannont...
  4. shyam131

    Exchange Server Calendar Share Set Up Help

    My company is moving to a hosted exchange service. I can't figure out what I need to do inorder to setup calendar sharing as I want. Here is how I want to set things up: Everyone can do whatever then want in their personal calendar. No other users will be able to see any other users personal...
  5. shyam131

    Ordinal Number Format in Excel

    Does any one know how to create a number format in Excel for Ordianl numbers. For example: 1st, 2nd, 3rd....25th. So that if i have a list of numbers I can change them into an ordinal format?
  6. shyam131

    Missing Value Lookups In MS Excel

    Using the match function works, in the sense that it gives me the desireed information, but I want something a little more savy, in the sense that it would only return the names of the missing companies. Right now I have a VLOOKUP that accomplishes that samething as the above match function...
  7. shyam131

    Missing Value Lookups In MS Excel

    I am using Excel 2002. I have a master list of companies and two seperate lists (LIST1, LIST2) of the companies on another spreadsheet. All the companies in the seperate lists (LIST1, LIST2) are not neccesarily in the master list. How can I look up which companies in the master list are...
  8. shyam131

    Linking Data from Access into Excel

    Sorry, I think you misunderstood me. I need to do the opposite. I have the data in Access and need to Link it into Excel. That is changes to my Access Database will automatically be updated in my Excel Spreadsheet
  9. shyam131

    Linking Data from Access into Excel

    Does any know of a method to link an Access Query to an Excel spreadsheet. One caveat I only need specific Feilds. For example if an Access Qeury called "2002 data" has Fields 1-10, How would I link Fields 2 and 5 into an Excel Spreadsheet? I know about DDE, but this seems to be...
  10. shyam131

    Conditional Max Min

    Bowers74, I am trying to implement your solution as an array formula, {=MAX(($C$2:$C$11<>&quot;Q&quot;)*($B$2:$B$11))} The max works great, but using the same formula with min does no seem to work {=MIN(($C$2:$C$11<>&quot;Q&quot;)*($B$2:$B$11))}???? The formula returns 0. Thanks for your help
  11. shyam131

    Conditional Max Min

    I messed around with dmax, dmin. But I am not sure exactly how to implement them.. Let me explain better with an example: Company Total Segment 1 23 A 2 32 C 3 45 A 4 23 Q 5 23 B So my pivot...
  12. shyam131

    Conditional Max Min

    How do you use a formula to create a conditional maximum or minimum similar a conditional sum? Is there a maxif function?
  13. shyam131

    Excel Pivot Tables &quot;Memory&quot;

    What versions of Excel Does this apply to? I am running Office 2000.
  14. shyam131

    Excel Pivot Tables &quot;Memory&quot;

    What does this code do that the refresh button doesn't? I ran the marco as you suggested but the original problem still remains. Is there any way to delete the pivot caches? All I want is for the pivot caches to &quot;forget&quot; everything but what is in the current datasource.
  15. shyam131

    Excel Pivot Tables &quot;Memory&quot;

    Have 100s of Pivot tables that organize data base on a list of companies. The list of companies if dynamic. It seems that even after a company has been removed from the data source the pivot tables still remembers the company name. These Pivot Tables have been used years and drop down list to...

Part and Inventory Search

Back
Top