I have an odd situation I was hoping some of you excel experts might be able
to help me with. I was sent a spreadsheet (task schedule list) that was
about 25kb (only 40 rows by 8 columns).
After I did some editing (adding 2 new columns and adding some information

Here's what I am trying to do.
I have a table of date, with the column names in Row 1, Column B-J.
The Data from B2:J11 is dates. On a second sheet, I have the dates
listed chronologically, I'd like to use a formula to take at the date

I have a list of data in cells d11:d15.  I want to be able to count how many
of  the data points fall within a certain numeric range (ie less than 100 but
greater than 50) but I want to be able to reference a specific cell
containing the criteria rather than using '100' or '50' ...

Good Morning, First time here so be gentle please,
A few years ago I did a HND in Computing and was quite into Excel, and
seem to remember using forms to input data and get report type outputs,
THIS WAS DEFINATLY NOT DONE IN ACCESS.

I used to use Excel a lot but haven't for a few years.  What is the
syntax for using a countif function these days?
"=countif(a1:a10,>b2)" used to do the trick  I have tried using help
but for some reason

I have a worksheet I created using Excell 2007. While I am trying to print
the entire worksheet, a Cross grid line comes up and divides the worksheet
and will let me print part of it. How do I clean it up. Thanks
Ajoy

I have created some new Heading Styles for use in a document.
How would I get them to be recognized in a TOC?
Are there specified Styles that ONLY will work or is there a setting to get
them to be recognized?

I have a table whose cells contain text. The lengths of the text strings are
unpredictable, and vary quite widely between different records.
To minimise the overall size of the table (for printing)  I use 'wrap text'
, and I juggle column width and row height by double-clicking on ...

I have a worksheet in which I enter data under 8 titled columns. After entering info on the 8th and final column, I would like for excel to sort by column 1, which is the date, and also lock the row, say row 24, preventing mistakes on previously entered transactions. If anyone ...

Cell C1 is protected and has the formula A1 + B1. The users in my office
sometimes cut and paste A1 and B1 to A2 and A2. After the cut and paste the
formula in C1 changes to A2 + B2. What I want is for the formula to remain
A1 + B1. Is there a way to protect or prevent cuts and ...

In Excel 2002, those little triangular comment indicators display in
the upper right corner of their cell.
I want them in the U.L. corner instead. Can I tell Excel to do that?
(There is no such option in Tools / Options / View's Comments panel.)

I have two formulas that work just fine.
However, I need to max out at value based on the weight.
Example.
D3 = The person's score (10)

Is there a way to copy a cell value into a cell comment?
thanks!

I'm trying to create a formula which will count the largest number of
sequentially non-blank cells in a column or row.
e.g. if the row had the following columns:

I've got several thousand loan numbers which need to be updated to a
ten-digit format by adding a leading 00.
That's easy enough to do, HOWEVER, some of them have already been updated
with the leading 00.