I'm looking for a way to limit the number of characters in a string of text
to 65 within a cell, so that characters > than this move to the next
row(cell) in a column. This is so the data passes validation on import to an
oracle database. I have tried the text to columns wizard ...

I have two separate worksheets with similar data, Worksheet1 and Worksheet2.
Columns A - F in each worksheet contain data. Column A in Worksheet1 and
Column A in Worksheet2 contain an account number. How can I compare the
account numbers in the two worksheets so that if the ...

I have an excel file with one hundred graphics. The data for the graphics are
put in the very first sheet. Behind the data I would like to have a button to
print out the graphics sheet that the data refer to. So I don't have to go to
the graphics sheet every time, and click the ...

How do I compara data in two columns...  Say have a list of names in one
column and a list of names in a second column.  How do I sort the names in
the second column to match the ones in the firs column?

I need to do a formua where IF E12/E10*100 is greater than (.1) AND less than
.1, Excel will return an em dash, otherwise (ROUND(E12/E10*100,1)

Sometimes our excel docs have their columns mysteriously switched from a
letter heading to a # (and rows are numbered) so that formulas cannot be
done. This "column numbering" seems to be contagious. If you have another
excel doc open, its cols switch from letter headings to #s. ...

can you run countif across an entire workbook without knowing all tab names
in the workbook?
If yes, How?
tia,

I am trying to check if the cells in A1 through A210 equals ADMISSIONS AUTH &
TRANSFERS and if the department question equals Very Satisfied in one
worksheet so that I can add the total number of "Very Satisfied" questions
there are. Is this the right way to do this?

I've been using these spreadsheets successfully for quite a while; now,
suddenly, the formulas won't run. Have I unknowingly pressed the magic keys?
How do I undo my error?

This is similar to other posts, but those posts weren't solved so...
I have a worksheet with (among other columns) a company column, and a track
column.  I just want to count the records where the company is something
specific AND the track is something specific.  I can only seem ...

Am totaling scores for each judge for a contest, and each entry is
judged in 3 categories.  Need to sum the remaining scores, by tossing
out that judges scores.
We need to disregard all numbers from Judge 2 in the total because they

I downloaded the MS Loan Amortiztion template.  I'm having a problem
because it only allows me to enter years for the length of the loan.
Some of the loans I have are not even years (37 months, for example),
but the template won't allow me to enter this.  Can you please tell me

The sheet calculates 6mo totals and averages.  Each month, a new column is
inserted and added to the totals & average, while the one from six months ago
is dropped. (column is retained for other reasons, just no longer included in
these calculations).  

is there a way to calculate an absolute value for a number in a cell?  for
example, if you the number in a cell is 2 or -2, the value given in another
cell would be 2.
thanks.

Please help! I need to install Excel Solver, but my Office 2003 disk is on a
ship from Australia to New York and won't arrive for 2 months. Does anyone
know how to install Excel Solver w/ out the Office Installation disk?