when making up a chart with myltiple columns how do I insert verticle lines
between columns

I have a software program that kicks out Excel reports with data fro
its fields and I need to add the cells up. I can put the =SUM(A1:D1
formula in a field within the software so it adds up A1 through D1 n
problem but the simple =SUM(A1:D1) then shows up in row 2. So where i

I have an attendance spreadsheet that i use at work.  I have a worksheet
for each year.  I but together a worksheet that uses vlookup to gather
all the information from the yearly attendance sheets.  The problem i
have is, i am trying to put together a worksheet that will take a ...

First off, It's always bugged me that there is no equal sign on th
number pad of my keyboard, it just seems like it's something tha
should be included in that set of keys
The other day I found that you can use + or - instead o

I have a list in Column H whose MAX size is H2:H10,000.  There are currently
only 1,000 cells filled in with data in column H.  I want to create a new
list in column K that will pull out ONLY unique entries from column H.  Is
there a formula to use that would calculate for the ...

I am trying to add two cells plus 30 and get a date. How would I go
about doing this? I have tried everything I know.
for example Q7-M7 or Q7-M7+30
Q7 and M7 are both in date format.

can Excel sum colored fonts?
grouping of currency figures in cells A1-F1
can excel sum on the the red fonts? the blue? and the black?
using this for an expense report and the users indicate cash purchases with

How do I concatenate Cell B3 & C3 and have a space between the values i
B3 & C3?
B3                           C3
423    "CHANGE-OVER" ADAPTOR

I have a complex task and I am not sure if excel can do this or not.
This is really important so any help is very welcome.
I have given severel people a servay. Each question has seven possible
answers. They are: strongly agree, agree, agree somewhat, neutral,

I need the information that is entered in the cell to automatically fill into
other selected cells.

I have
21 columns A to U, and 600 rows.
I want  use look up function for the maximum to return the value from the
first column (A) from the same position in each column without ordering each

I have done a excel work sheet to work out my wage but I am just stuck on one
thing. When I work longer than 8 hours I get an hours dinner brake unpaid.
I’m know wanting to know if there is a formula that works it out. In Cell B2
I have the time I started and in C2 the time I ...

I've used the suggestions here to change all lower case names to Proper and
to no avail.  Column A has the names.  I put the formula in B and then did
the copy values back to A.  Didn't work.  What did I do wrong?

I have 2 worksheets.  1 is the destination sheet and the other 1 is the data
sheet where I want information from.  I want to extract the following data
from the data sheet. These are the personnel id, employee name and cost
center account.  What I want is if I fill in the ...

I have a V-Lookup that contains email addresses.  But when it transfers over
to the other sheet, the link does not work.  Is that possible to make happen?