Dear Excel(lent) users, I have a list in which al sent requests are logged. Every request has a priority, each priority defines in what time a request needs...

I've got a 7 column EXCEL sheet. I want to eliminate duplicate entries. The problem is that I need to locate duplicate last names in one column and then...

I have a large set of data with many entries. I need to find all instances of any given value in the first column and then return the maximum and minimum...

Does anyone have any suggestions on how to remove macro as I open worksheet? I have already checked and delete all macro within the spreadsheet, but whenever...

I have a colum with a list of ID's and another with a list the corresponding names. The rest of the spreadsheet has colums of the same Id's. I was hoping to...

Hi I am trying to add VAT to a column in my spreadsheet but it doesn't seem to like the funcion i type in, can anyone help.

Let say i have this date range: 01.02.2008 01.02.2008 01.02.2008 15.02.2008 29.02.2008 29.02.2008 11.04.2008 02.05.2008

Hi How can I do the following. I have a spreadsheat with the 12 columns representing months. If there for instance for one row in May there is value 6 the...

Hi, I have been given a lot of data which is formated in the wrong way and wondered if there was a solution to format it into the right order? The data looks...

In the old days you could insert a document path of where the document comes from, called document stamp, I cannot find this feature, is it still around, if...

Hi guys, basically I need a way of locating a name along a specified row and returning the value n rows below that name. For example I have a target cell...

I am endeavouring to choose quickly from a list defined in a cell created in excell. i.e if the list is: Excellent Good Fair Poor ICan you get the cell to...

Hello, I have drawn a horizontal, clustered bar graph. On this graph, I would like to add a (horizontal) line graph. This does not seem to be possible. It is...

Arrrggghhh I'm tearing my hair out with this one. I need to create a formula that will look up the data from 2 seperate cells in 2 colums and return the...

Two things: What would the formula be for the following: If D10K10 and 0, then L10 (this would put the value in M10) and If D10 K10 and 0, then...

I produce workbooks for an office where 200 staff work and use my shared workbooks. Read only access is available to all and managers (25) have write...

In my excel project, I've created a drop down menu in one cell. In the adjacent cell, I want to have answers automatically generated when you choose one of...

Hi, I was just trying to create a formula to automatically calculates the date from the pasted in value, example: Oct 22 2008 02:33 pm Considering the...

I have a Excel sheet with various data that I want to sort by A-Z, the problem is I have equations the do not sort correctly. Example: Befo A1 - Mouse B1...

I enetered data in multiple rows and columns. I clicked on the "format as table" in the "home" tab and now i can only get to my data through the drop down...