Given a column of cells each with text in the format: LAST NAME, FIRST NAME ..... like "Jones, Bob" and "Johnson, David", is there a quick...

Is there a way to prevent duplication of numbers in Excel cells such as Social Security Numbers. Can an alert be set to get notification when a duplication...

Hi there, I am wondering if the basic edition does not carry all of the functions available for use. I had designed an excel sheet for a friend and it...

I am trying to create a formula that will count the total number of cells that meet multiple criteria, including a "does not equal" criteria. Basically, I...

When I do a mail merge of an excel spreadsheet, the first zero doesn't show up. The column has a zip code format, and the actual cell shows the zero, but the...

I have a database with the following columns: store number, date (YMD) & costs. The database covers several years. I need a formula to sum all costs for a...

2007 UK Excel Conference - Nov 29 - Dec 1, Cambridge, England. Only a few weeks left. You will not want to miss this event. Featuring presentations by Simon...

I have lost the restore button on the worksheet and have a small worksheet that I can not maximize now. How do I get them back?

if I have theses number 17 18 100 70 and 65 I want theses number answer will be com 100.215 MS excel

I am trying to figure out a formula that will automatically figure retainage for pay applications. We keep 10% retainage until we reach 50% of the total...

I wondered if its possible to create a brochure that would contain pictures from a stock list that I can call to show the garment as well as price. I have all...

using office 2003 excel what i am trying to do is do a drop down box one with a date and one with time tried using the validation tool but it just gives me...

How do I set a check box to change the background color of a range of cells? Thank you, Brian

In column B I have the dates listed from 01/01/07 through 10/31/2007. In column E I have totals for each day. What I would like to do is have an average...

I know it is possible for formulas, etc, but is it possible to have a macro that formats a column of cells and only formats down to the last row? It will...

in my database I am copying a number of cells from one sheet into another and using paste special/values. I then run a macro to insert a line which moves...

I want to change the Column Letters to reflect the 12 months. Column A - rename to January. Rows will be my construction codes..not Row 1, Row 2, ect... How...

I am trying to sum up a column a data which includes numbers and the #N/A indicator. These numbers are from a vlookup formula. The column is in a spreadsheet...

Thank you Peter Appologies posted and couldnt see it.