Hi All, I have a pivot table which looks at my stock file, and report how many items in stock, the Parts(ID) are classified as WI prefix for Work in Progess...

Hello, I tried a suggestion from another board (the Charting board, actually), but I am not yielding the intended result. I hope someone from this fine group...

I think I need a nested IF statment to deal with the following. if value in K8 is "Non Asbestos" then C15 = 0 if value in K8 is "Chrysotile" then C15 = 1 if...

Hello, I am working with a group of individuals that will be passing around an excel spreadsheet to one another, and wanted to come up with a way to have the...

Can someone please help me with the following problem as a whole day of surfing over the internet did not help: I want to make a selection that when column A...

A dozen google searches didn't solve this problem, but I know you can... I have a row of data (I actually have a lot of rows, and a lot of columns): I need...

Hi All I have a pivot table that is generated from a database (example below) that will continue to be updated and added too each month for a year: Product ...

Hi I have a column displaying worksheet names, is there a function that will automatically change the name in the cell, when the worksheet name...

Hello, I am trying to figure out a countif formula. Here is the explanation: Worksheet one (my data dump page): In column A I have store names listed. In...

If I don't have MS equation installed in my MS excel how should I install it from my MS office CD?

I have a sort problem I'd like some assistance with. I have a function that is returning the following concatenation from a column range....

Hi there I want to apply a conditional format to a cell to see if a date is present. eg if there is a comment like "SEE JUNE" it becomes red text,...

Say I have a list of player names on a sheet, with various columns for different attributes, including "position" Is it possible to have a second sheet that...

Does anyone know if you can change the font or shading of a cell by rolling the mouse over it? I have a worksheet where the user has to make several choices. ...

Hello, I am trying to figure out a countif formula. Here is the explanation: Worksheet one (my data dump page): In column A I have store names listed. In...

I have a worksheet with 8 total columns. Columns five thru eight are laid out the same as one thru four. I need to sort the info in columns one and five in...

I want to be able to set a reminder in an outlook calendar from a column in excel when that date is near.

Trying to build a formula for a tiered commission plan so that the sales person can calculate commissions based on the number of accounts and dollar volume of...

Hi I have a question Iam not able to find exact answer and my excel skills are not very high-end So, I have a Excel document that has Main worksheet and...

Hello! I need to filter unique records acording to two columms (10xy and error). I want the unique ocurrences of this pairs of columms independently of the...