Hello all, Please note that I have ben asked to create a spreadsheet that will generate a report for staff working in a call centre. The basic form is as...

I am trying to complete the following. In s141 i have a drop list with 'yes' and 'no' as possiblities. In x141 i have a drop list with 3 possible choices, ...

How to put the total number of sheets in a work cell? Thanks

Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest...

I am sure I've done this before. somehow it alludes me all of a sudden; I have a table with ProductName | Amount Sold Where Product Names can...

I have made a timecard with excel everything is working as planned except for one thing. I am unable to get the roper formula or function to calculate my...

Hi everyone, I've been using...

I need to find how many times Dan occurs in a certain month. Example Below. A B 1 1/2/10 Dan 2 ...

Hi, Is there a way that when you insert rows, the conditional formatting on the adjacent rows does not copy into the inserted/new row? Thanks,

Hello, Im trying to add the amount of time spent on a type of machinery based on a 5 day week period. For example from 3/1/2010 to 3/5/2010 not including...

I have this formula: =OFFSET(INDIRECT(ADDRESS(MATCH(MAX(B1:B26),B1:B26,0),2)),0,-1) It looks up the value one cell left of the largest value in B1:B26, and...

Hi, I have a list of vendors, each having done work on several different dates. I need to find each vendor's latest worked date and display them on a...

I have 9 columns and 52 rows that that have pricing for 9 brands for each week of the year. There may be some weeks where a brand as $0.00 as a price. I am...

Got a chart that I inserted graphics on but when doing a print preview, it does not show nor does it print when using excel ver 2003. Home network it to my...

How do you turn on the recent documents feature in Excel. The help section says it can be turned on and off, but does not state how to do it.

I have a table name a 15 name b 16 name c 18 There will be 80 names and 54 numbers (1 to 54). I need a formular that would search the...

I am trying t convert 2 cells, but i only want to merge if the total characters does not exceed 70 characters, can anyone help me with a formula for that?

I have big database of customers and have blank space beoire the customer name start. How can i remove it in bunch? Dinesh

I am making a program in excel for some time cards then workbook starts with sheet one to change the date next sheet has the list of names with all the info...

The numbers represent rounds. So a name will go with a round (number) but some names know more than one round. Name a 1 name b 2 name c ...