A new software program insisted I change my desktop resolution to a higher setting than I've used for years. I did so, which in turn gives me a broader...

Using Excel 2000 / Small Business Exchange Server / XP Pro I created a simple macro in Excel 2000 and assigned the macro to a custom menu item on the...

When I download contact address information from Outlook to an XL file, many times there appears a square 'box' character in the cell where either (a) a...

The boss wants an inventory count of cars on any given pass date. The existing table has a DELIVERED date field, for when the car is entered in inventory;...

Hello The SUM function allows up to 30 numbers to be added =SUM(number1;number2;;;numbern;;;number30). Is there a way to modify the settings of this function...

I have a spreadsheet which already contains the following...

Dear All, I am looking for a formula that will change all the cells value if that contains the specified word. e.g. GPS Ignition off Unlock Ignition...

Hello, I have a locked worksheet distributed to users where they insert certain values. One of the fields is for currency and I want to code it so that it...

I need help creating a formula. I have an Excel 2003 Worksheet that contains information. I would like the formula to look at the column ProductID where...

Want to fill down with the mouse without going to the next number in a sequence; IOW: If A1 is E76D3456-1, I want to copy down using the mouse without having...

Name Jan-2008 Feb-2008 Mar-2008 Apr-2008 May-2008 Jun-2008 Big Blue X Above is an example of the spread sheet I am trying to populate. What I need to do...

I'm brain dead and tired of looking at this. I need to add this primary condition: IF($BH11=0,0,... to this...

=IF(COUNTA(INDEX(F:L,ROWS($1:20)*5-97))=0,"",SUMIF(INDEX(F:L,ROWS($1:20)*5-97),"0")) The function above is what I want in cell T20. It works fine until I run...

I have possibly screwed up in a big way. In my spreadsheet I have assumed that records would be added chronologically (as they should), and did not allow...

Hi I have the following cells D1 = GRAND TOTAL (including E1, F1 and G1 amounts) E1 = 10% of D1 F1 = 7% of D1 G1 = 5% of D1 When I put a figure into D1 I...

hey!! i'm working now with dynamic range for single column and charts. i've a chart with number on the y axis and dates on the x axis and i would like to...

Hi All, When i am writting worksheet-Printout( parameters ).. Its showing dialog box for few seconds. How to avoid it? Regards, Sachin

I am creating a catalogue using Text format where some measurements involve fractions. How can I get them to display in diminuative form (vertical) instead...

I want to be able to look up all occurances in column A for 1000 and add the corresponding results in column B. So that column E will show the results for...