I'm in dire need of help I have a column of 2500 entries that account for no more than 10 duplicates. So I know there has to be at least 250 unique entries. ...

My manager has asked me to enter an excel formula which calculates the total number of leave types taken per staff member. The data is derived from a table...

please help me to configer the excel worksheet in such a way that it saves all the files i create automatically, can someone tell me the steps

i HAVE A SUMMARY WORKBOOK WHICH AUTO UPDATES FROM 3 OTHER WORKBOOKS. THESE 3 WORKBOOKS ARE LIVE DOCUMENTS AND WILL BE RE-SAVED CHANGING THE REVISION NUMBER...

Everytime I copy a sheet to a different file, font color changes. Is there something that I need to do to avoid this? Thanks,

Hi, Trying to create a formula which will check the start date = 01/01/2005 and then check if a staus = complete and if these are both true then add 3rd...

I am trying to create a formula on a 'summary' sheet that will be the average of the same cell on a series of 'detail' sheets. Using the AVERAGEIF formula...

I've created 2 sheets with data that have to be plotted on different charts. I then created 1 sheet just for those charts to appear. On the first data sheet,...

How do I insert a new line in a excel spreadsheet without destroying the consistency of the formulas? Cut down to a minimum, the following is what I...

Good Morning, Afternoon, Evening (Depending on where you are) I have put together a TimeSheet that allows the user to select a type of leave that a person...

This is probably something simple, however I am knew to excel. I am creeting an simple electronic diary. I have a column of dates (A14:A74) and would like...

I'm totally in the dark on this so any help would be greatly appreciated! I have a spreadsheet that lists my call center staff in one column and their...

Hi All, I'm having troubles writing this array based on criteria I hold in Column...

I want to count the number of cells that have a date entered, in a period of 30 days, in a column with over a thousand cells. Some of the cells are blank...

Hello: Whats the shortest way to check with a formula if the result of the cell is the same of another cell on that same row? If I have in Cell A1 521, and...

I need a formula that can calculate the following: If month($B$2) equal month (D10) the maximum it can calculate to is 1, otherwise add D11+D12-D13 The...

Hi, Can someone help me with this: I have the following type of data: Itam Tag Last Updated Date AAA 01-Jan-09 AAB 01-Jan-09 AAC ...

For example cell B2:B11 contan the following: Ralph Reinhart, Roadmaster John Wodehouse, Grounds Manager Wendy Becker, Treasurer Jane Bender,...

Can anyone help me use a greater then constraint on a specific cell as part of my sumif function. For example the following formula works...

I created a drop-down menu from a list of names, but now I need to add another list of names as well. Because of the grouping, I can't just add the names to...