I'm trying to get the sum of a list of numbers that start with a certain number (in this example 1). I can't seem to make any wildcard work. My numbers all...

I have imported my contacts from outlook into excel and having trouble with the phone numbers. for some reason sorting does not go as it should and a vlookup...

Am I missing something? Is there no way in Options to change the default font & size, permanently, for every spreadsheet or workbook that you open, without...

Is there a way to clear all shaded cells in a worksheet using a macro? I have received a lot of help from this news group. Thank you very much.

I would like it to display the results of a cell formula in the same format that is in the referenced cell. For instance (simplified): Cell A1 is formatted in...

ID...

can anyone help me figure out this problem? I have an drop down option list, and i would like to create an if statement that will hide select rows depending...

Hi...

Hi there, I am having problems finding a solution to a problem I have been given. I have a workbook which on one sheet we log: Job No Weekly $ ...

I have the following code that gives me a #N/A for some cells. I want to change it to "" using an error statement such as =IF(ISNA(.... Can anyone assist me...

Hello. I have a spreadsheet that has two cells -- Cell One is always today's date using formula =Today(). The second cell is a date in the past. How can I...

Hello, I'm new to excel, I'm trying a simple formula (=40-C3-0.2) & I'm wondering if it is possible to hide the result of my formula until I had added an...

I have a file with 20+ worksheets that keeps increasing in size. They are not, unfortunately, in any alphabetical order. I'd like a table of contents page...

I am trying to get a 12 cell average within a row, starting with the first non-blank entry, working from left to right. All entries are numeric. The following...

Hi all In Column AA rows 8 thru 13 I have a list of names. These names vary as we move along Columns In AA14 I would like to place a countif formula to give...

I'm trying to increace the accuracy with which EXCEL reports the time. I'm using the NOW function to write the time that an entry is entered into a...

I am creating a spreadsheet and would like to know if I am working in row 1 and I make add, update or change informaiton in cells B1, C1 or D1 is it possible...

I have database files that I import into Excel 2003. In certain columns there are unicode characters, e.g. ╜ . I use the find and replace function to...

How can I calculate age accurately? If I put in the following two dates and use the "Callculate the number of years between two dates" function, I get 26 as...

Hi, I need to create either a macro or condition formating so that i can change a field from its defualt to green when a job is done, and back to its defualt...