I am currently searching for a method to do a similar formula in excel.
I currently process around 120 students every 2 weeks into classroom databases. Currently when we recieve the spreadsheet, the names of students show as:
last, first middle initial in cells A1-A120.
I was ...

I have some cells formatted in blue font & green background on my worksheet.
Is there a way for conditional formating, or some other way, to make them
invisible ? I need to provide most of the data on the worksheet to others,
but I don't want them to see those blue/green cells.

I have 2 worksheets that I need to bring together into a single worksheet.  
The first column of each worksheet is the "persons" ID number.
I want to append the data in worksheet 1 with the data in worksheet 2, based
upon

If today is 08 NOV 2008 after Three or six months later what date going to
be. How can I create a function in MS Excel. Can you please let me know.
My e-mai is shahin512@hotmail.com
           or

I have a spreadsheet with 5 columns:
A = date an e-mail received
B = time e-mail received on that date
C = date e-mail replied to

please help
how do i give a tab of a worksheet the same name as a cell in the worksheet,
automatically

I need to update a fairly large spreadsheet so that all numbers are rounded
up... using roundup()
Ive looked around and ive come to the conclusion i need to use VBA.
can anyone help?

hi there!!
Am New to this discussion and its this problem that brought me to this
discussion....
its have got to adjust values in Col E to 30, if it exceeds in Col D where

Can someone help please!
I would like to format cell colors based on values that are in the cell. The
numbers in the cells are alpha-numeric order numbers followed by a number of
days in the sytem (e.g. x12345678-14). Some cells have up to 14 "orders" in

I have a spreadsheet with several records for each machine's name as
illustrated below:
Server Name / Database Instance Name / CPUs / Concurrent Access
______________________________________________________________

in excel i have a coloum F and it starts from F10 to F165 now how do i appile
filters to them all
i want to be able to use just use the drop down for the user to select what
departmet they need and in the drop down their is going to be a list of 17

When using excel some menu options that are not used frequently eventually
are hidden by the system until you expand the menu, however when an option is
used once that option is displayed again until the expiration of the display
period and then it is hidden again.

I have an issue with the XIRR and XNPV functions in Excel 2007.  The formulas
seem to be operating properly, but when I go back into the spreadsheet after
closing it, the cells where the formulas were now say #N/A.  I have not made
any changes to the spreadsheet.  I do not have ...

Hi;
Appreciate if someone could help me with this:
I have a spreadsheet that contains a column for the user to indicate whether
they want to "Update" or "delete" the request.

G'day there One & All,
    I've used XL to try to solve a simple trig problem, but the
results have thrown me somewhat. I've no doubt the fault is mine, but I
can see what's wrong.