I have a column with numbers some numbers are the same.
I need to total how many times a number row appears; group it; then total
another column number value and place blank rows inbetween each.
Like this...

I have a workbook which creates and names extra sheets dependant upon the
list of names entered on the Set Up Sheet.  (Range B16:B20).  These sheets
will always be Sheets 3 - 7, but not all of them will always be in use (If
for instance there are only 3 names entered and not 5), ...

In a protected worksheet, I want to enter a single digit in an unprotected
cell, then have the cursor move automatically to the next unprotected cell.
How can I do this?
---Patrick Riley

Can you suggets how can i change the format of my cell to accept
percentage with two decimal places?
Since, i am adding a new worksheet in my code, i also need to make
sure that the cells have percentage format... have a look

Thanks in advance for your help.
I'm trying to copy some data from my worksheet to a new sheet. The
background is like this:-
 Column A         Col B          Col C       Col D

i need to do a calculation.   Example:
I have a Figure i.e. 3 Years     10 Months    and 28 Days
If I add 1one, 4 months and 4 days to it, normally the result will appear as
4 years, 14 months and 32 days.    What I want is to have the result is 5

How do I convert a string that contains letters and numbers
into a number using Excel2003 (or ms Access)
e.g.  "£2,456.99 (including flights)"
==> needs to be converted into the the numeric 2456.99

I have a spreadsheet to collect address information.  Below the address I
have 4 checkboxes to describe the address.  User can only select a max of 3
from the list.
CKB#6-Payments

Hi I notice when I do the standard IF function using the Wizard I am given
three boxes:  
Argument
True

How do i get my total answer to my maths sum, i have pressed enter and return
but dont get a total Thanks Marilyn

Hello,
How can I add "00" & "0" to the the following cells:
(A     B  )   Result  C       D
(1     72 )              001   072

My problem is: I have a number of two rows. For example think one row has
the data of student i.d. and another row has the grade they achieved in the
exam. What I need to know is there any equation in excel which will help me
to copy the data of row 1 & 2 according to the ...

I would like to be able to pull out certain numbers (B# in below table) from
a list A# in below table and copy the associated row values. In the example
below, starting with the left three columns how do I go to the right three
columns given the B# value column.  

just want to put price per unit and the number of units with dollar total
cant seem to get it right...

Hi guys! Seeking for your suggestion. actually, i'm facing a problem with my
excel programme (excel 2002- xp). The problem is, I have a big file which
contains a lot of data and i'm using filter to expedite my work. but from
yesterday, when i opened the file and click to the ...