Hi All, I have created a Pivot Table as Below: jan feb march april may june etc Shop1 10 12 ...

I created a table with a range of "A1:I6". In row 1 starting from A1 I have these headings: Team Play Win Draw Lose GF GA GD Points In column A...

I have a remarks column of text data that I need to split into multiple columns based on a date in the text. Data in this text column is grouped by, for...

I need to compare the data in two worksheets and either highlight the cells that are different or produce a new worksheet with the different values. Barry

Hi there, I have 12 worksheets (months) with a total in a single cell on each sheet, I'd like to average them on a summary sheet so I have one overall...

Hello, I have a worksheet that has several hundred rows and in 1 column I want to add 2 words before the text that is already in the rows in this...

This is probably very simple to do but I can't seem to figure it out. I would like to fill a cell with a color if the value of another cell has a particular...

I am using MS-Excel-2007, and My excel file contains approx 2 lac of data, and the file hangs a lot when i filter out data from it, or do any kind of...

I need to create a spreadsheet that compares two different data base reports from our software program. One is an open PO report, the other is an open order...

Hi, I have a large number of formulas that link from one work sheet to the other which also use IF functions. Is there a quick way to change the IF criteria...

I have an excel worksheet that is 341 columns by approx 50,000 rows. In column A each row is given an identifying letter of A-E based on the information...

Solver error "can't find project or library" when I try to run solver from a macro. Works fine in 2003, but not 2007.

Is there a Function/option to change a range of sells from negative to positive without making the font red ?

Here is the problem, If the source field name of pivot table changes how it affects the pivotfield in the pivot table. What is the setting which allows the...

Hi, Am using Excel 2007 and have a date sheet and a summery sheet, e.g. Date...

I have my excel spreadsheets and set up the autosum, both manually and using the approciate keys however they do not automatically updating the totals, I...

I have one worksheet that holds data that I need in another worksheet. I do not want to copy and paste, because all of the data may not match up. Is there...

Hi, I have a table where I need to lookup a rate based on the employement date. The lookup fields have a date from and date to and a rate. I want to lookup...