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
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...
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?
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...
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...
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
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...
Bowers74,
I am trying to implement your solution as an array formula, {=MAX(($C$2:$C$11<>"Q")*($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<>"Q")*($B$2:$B$11))}???? The formula returns 0.
Thanks for your help
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...
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 "forget" everything but what is in the current datasource.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.