Search results for query: *

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

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

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?

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

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

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

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