how do I annotate a formula in a cell in MS Excel 2007?

I have a file with 10,000 plus rows of date that I need to prepare a running summary. Column A = site location Column B = shelf name Column C = slot number...

I have a training spreadsheet that uses the date function "Today" along with the date training was completed to calculate when training is overdue. Is there...

I have a formula with criteria which excludes "0148" from the sum. =SUMIF(E$51:E$56,"0148",O$51:O$56). I would also like a formula which would exclude...

Hi I have this worksheet 25 apple 15 banana 30 cucumber 5 tomato If I use vlookup or lookup function, the data should be sorted, the default of these...

I have several workbooks for 1 office-1 main workbook in which I would like the data to flow into 3 seperate workbooks. I would like to place a formula to...

Looking for some help, where I work the old system for booking out items from our store involved a pen and paper, ive now computerised this. I now have the...

I have a column of cells which are formatted as either General or hh:mm. What I want is - if A1 = Off & A2 is less than 06:00 then A1 is highlighted in red...

I have a worksheet with data. I need to match the date and the shift and return the value to a summary page. Sample...

I am trying to count the number of cells that contain the number 1 within the data below. The formula that I am using is =COUNTIF(A1:A14,"1"). With this...

Using Excel 2003 I have an Excel report that has over 2,000 rows. I want to delete the rows where the text/numbers are NOT bold and keep the ones that ARE...

Trying to format a cell and text, need to keep zeros in front but also need to custom format to be a upc code. Need only 12 characters and need dash in the...

I wonder if there is a quick way to put the sheets within a workbook into numerical/alphabetical order.

Basically, I am trying to create an if then else statement in Excel and I have no idea how to do it. What I am trying to achieve is... IF ( K2 between 8...

I am not even sure if this is possible or not. If J is more than 11, but not more than I, I need to know what is J minus D

how do i get formulas to print?

Okay, I need to calculate a total based off of two conditions. I am assuming their is a way to do it via table, which I am unfamilar with. Is there an easy...

Hello, for the life of me I can not figure out what is wrong. I have used this feature in the past without problems. I have copied and pasted the contents...

I have an EXCEL 2003 workbook that contains addresses. The "Street Number" is in one column and the "Street Name" is in another column, like this: Column A ...

I have put together a spreadsheet that we use to be sure that I am complying with complicated coding (billing) rules. The form has about 100 check boxes...