|
|
Product Trends by
mike
Hi All,
I have created a Pivot Table as Below:
jan feb march april may june etc
Shop1 10 12 ...
|
|
1 |
56 |
|
|
Auto sort by
MAX
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...
|
March 19th, 2009 05:48 PM
by MAX
|
3 |
81 |
|
|
Split Cell using If or other function by
JPS
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...
|
March 19th, 2009 04:50 PM
by JPS
|
0 |
307 |
|
|
Compare data in two worksheets by
Barry
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
|
March 19th, 2009 04:21 PM
by Barry
|
0 |
61 |
|
|
Average across selected worksheets by
Stephanie
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...
|
|
1 |
59 |
|
|
|
March 19th, 2009 03:36 PM
by John
|
9 |
102 |
|
|
Conditional Formatting by
mykcap
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...
|
|
2 |
63 |
|
|
Excel Hangs while filtering by
Database_Aforeserve
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...
|
|
1 |
55 |
|
|
Formulas in excel by
Miss Ellie
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...
|
|
1 |
72 |
|
|
Mass Forumla Change by
Ghalmaraz
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...
|
|
1 |
70 |
|
|
|
|
1 |
79 |
|
|
XL solver macro by
brdotter
Solver error "can't find project or library" when I try to run solver from a
macro.
Works fine in 2003, but not 2007.
|
|
0 |
102 |
|
|
|
|
2 |
360 |
|
|
|
|
1 |
87 |
|
|
|
|
0 |
48 |
|
|
|
|
0 |
39 |
|
|
|
|
3 |
80 |
|
|
|
|
2 |
68 |
|
|
|
|
1 |
72 |
|
|
Lookup between two dates by
Nikkiv505
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...
|
|
3 |
62 |