In a column of a spreadsheet I use at work is data for the number of
transactions of different types, in a precise format (2 buy, 3 sell, 5
sell, etc). I have to total the transactions of different types, and I
thought I could get excel to do it for me. More than that, I thought a

I can align and distribute text boxes on my form with the options in the
drawing menu.  I cannot align or distribute option buttons or check boxes the
same way as I can only select one at a time.  Ctrl-select or shift-select
does not do it.  Any help greatly appreciated!

I am able to pull through data with the formula posted below, however the
ranges need to be dynamic since the range is expanded daily. The ranges are
setup with range names. However, when I attempt to change the hard coded cell
references to range names, the formula retuens a ...

Greetings!  
I have two worksheets, one is an old database and the other a newer updated
version of the old.
So far, I have named the range in the old and have applied conditional

I would like to place a button (or two) on my toolbar that has a different
format than those that are already there. It is one that I can get to by:
Format, Cells, Number, etc.but I would like to skip these steps and get it
on the toolbar. Thanks...jcs

Hi, I am doing some programming where I need to know the number of digits of
the only decimal part of a number. I ended up with the following equation:
In cell A1 I entered a decimal number.
In cell B1 I wrote the following : =LEN(A1-INT(A1))

I have created a spreadsheet with about 6 tabs.  Often data on tab 1worksheet
is found again on tab 2,3,5,6.  I would like this data to be auto filled so
that changes only need to be made on the first tab.  the change will then be
updated to the other corresponding cells with the ...

Is there a function to keep track (count) of how many times a particular
cell, the date in the cell, has changed?  Thanks!!!
R

I am making a form whereby the customer able to select what type of account
they would like to apply. For eg. there are windows and unix accounts.
Whenever user choose windows, there are bunch of necessary blanks pop up
below relating to windows and vice versa. Which function is ...

I have added shadow to some cells. Now I want to remove the shadow.  However,
the "no shadow" slection is greyed out. Can someone help me with this?

Hi,
I have two columns containing names.  there are some spelling and other
errors.  I am trying to use a search function combined with an array and
Left(cell,4) functions to determine if the first four characters in the

I have an Excel worksheet with many rows of data I that I will need to
sort/anyalyze.  The data is from accident reports and has columns with
information about the accident (location, weather, speed, injury, vehicle
type).  If mulitple vehicle were involved in the accident, it ...

Is there a way of creating a pareto chart in Excel 2003?
Thank you, Karen

This worksheet has 5 columns of numbers when the columns are added =sum
formula to add down it always returns on a 1 as the sum total and not add the
entire column.
What is it doing and how do I fix it. Is it something global.

it can be use to do all form of arithmetic calculation