I have a table used for attendance tracking of violations, using a list of Alpha codes: L = late, A= Absent. I then count these text values by using...

when working in excel can I make an action date and somehow connect it to a calendar that tells me the due date?

I have invoice numbers in column A (1234567ABC) Date of invoice is in column B in this format 31-Mar-09 Date of product received is in column C in this format...

I have many email addresses in one cell, how do I seperate them to individual cells? Please help. Thanks. Mukesh

Dear All, I have 2 workbooks = BookA and BookB In BookA, I have these tables CODE FRUIT APP APPLE ORG ORANGE

1. I have a column of values in A:A 2. I am trying to make B:B the Weighted Average of A:A where the Weighted Average is defined as, WA5 of B3 =...

What is the formula to replace "-" with space starting to count from the right side. I need this to be done in a whole column

What is the shortcut for getting to the beginning of the cell and the end of the cell? -- Tammy

Hi Is there a way to count total number of values based on the cell color? If there are three different colors thru A1 -A50 and the names are color coded, is...

I have 100+ workbooks. each have to remain separate. I created a sheet to add to each workbook with specific formatting. I tried copy and paste, and lose the...

At work I am able to zoom with the scroll wheel on my mouse. I was wondering how I would be able to do it at home on my home computer for office work? I am...

I have a pivot table that has several column fields and 2 data columns with a calculated data field variance (data col1 - data col 2). There are also...

Hello, Will someone help me with this? I need to change this formula so it will round up to the next whole...

forget password in excel 2007, how to recover the doc, because it is very important information in the ... I would appreciate help they beg! my e-mail:...

Hello, I have data files (1 per day) that are downloaded from a vendor site. The files come accross with a WR1 extention. I beleive this is a Lotus Syphony...

All, I would really love some help. I'm a novice at building formulas, so I'm looking for some help making a formula for calculating growing degree days. ...

I have an Excel document that includes a list of e-mail addresses as well as other data. This was saved as a .txt file. When reopened, the double quotes...

I would like to know if I can change the font/color of items I a, saving in a dialogue box. For instance I have a "Save as" box for Purchase orders that...

How can I make the date in the header apear as April 30, 2009 instead of 4/30/09?

I need to highlight cell B if it is greater than cell C of the same row, providing that cell C is NOT blank. All cells formated as date. Thank you.