How could I lock a single cell and selected cells in a spread sheed in
excell? If you could inform or respond to my email address please! Thanks...
My email: <master7lord@hotmail.com>

I'm sure there must be a way of doing this ...
I have 2 columns of data, with around 2,000 entries in each.
Items in Column A tend to be one from a list of c 10 different variables,
whereas Column B contains maybe 300 variables.

I have made a simple gradesheet for recording students grades, an
progressively calculating the average letter grade for each semester.
This works fine, except I need it to round-up to the next letter grad
when the points are 0.75 above the assigned grade value.

How can I convert positive numbers to negative numbers without retyping each
entry, thanks

I have a table in excel that i use on a regular but varied basis. It is date
specific. 20 columns show the day and date. rather than have to type each how
can i set up function that I just type first day/date and it auto fills rest
cheers ant

Hi Everyone...
Here is what I am trying to do...be patient...it's long.
I have columns lets say A,B,C,D
In column "A" I want to input a name and have it pull all the

I have a lenghty list of data all within one column (ie; rows 1 - 2000).
All of the data consists of a branch name followed by some figures in
brackets, ie:
Southampton (12345-654)

I'd like to calculate standard errors of the mean using the Excel function
tab... any idea how you do that?

How do I do a Countif of cells A1:G1 to check if they are equal to or less
than the value in cell A5.
TIA
Harry

What is the formula used for function "CENTILE( )"?

I have one excel sheet in which id and name is shown combined. So i
want to show id on different column and name on different.
So is there any way/ formula in excel sheet to differ it?
Example:

Kindly guide me how to convert from number to word in excel.
Thanks!
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the

I have been trying to do a vlookup for multiple data i have already asked
this question on this forum and the response was to use index and match which
I have been trying to do but it stoll does not work.
My query is on excel;

I am currently trying to analyse data from a questionnaire.  The
questionnarie is displayed on excel.  There are a series of questions on the
left hand side, & the options listed below are along the top of the
questionnaire:-

I'm using Excel 2003, I'm trying to write a function that will return the
value of a blank cell in cloumn 3 when cloumn 2 has the highest number
entered in it
B       C