|
|
Extract unique data by
eva cheng
I am using excel 2003
I have a file like below
Rate month GBP
1.46 FEB 2000
1.47 MAR 3000
1.47 APR ...
|
|
3 |
234 |
|
|
*****still can't post a question***** by
Simon
Hi
sorry for the asterisks but I am determined to find this question!!!
I have posted 3 questions this week which have not appeared in any forum,
let alone...
|
|
3 |
340 |
|
|
|
May 7th, 2010 05:28 PM
by Bob I
|
1 |
254 |
|
|
|
|
2 |
290 |
|
|
Macro match function problem by
Asraf
Hi all,
I have a problem to create a match function macro with the following
senario, whereby the lookup_array is currently at col D1 to D4, and the...
( 1 2)
|
May 7th, 2010 05:25 PM
by Asraf
|
12 |
479 |
|
|
Conversion of Nested if Formula in UDF. by
Aligahk06[_2_]
Dear All,
Can i convert the following formula in VBA UDF.
=IF($B504="NEW
INSULATION",CONCATENATE($B504,$D504,$C504,$E504,$G504),IF(AND($B504="NEW...
|
|
2 |
330 |
|
|
|
|
1 |
295 |
|
|
Forecast with two unknown variables by
Crutch
I'm hoping this is an easy question but I can't figure it out for the life of
me.
I've simplified my scenario down to two variables, order quantity and order...
|
May 7th, 2010 04:43 PM
by Crutch
|
4 |
266 |
|
|
Tracking Historic Data by
Ruth
Hi
I have a spreadsheet which is updated once a month by several other users,
on this spreadsheet i have a summary page which returns me the total number
of...
|
|
4 |
242 |
|
|
printing an excel worksheet by
lvachon
How do you print an excel worksheet without the alphabet on top and the
numbers on the left hand side
|
|
4 |
179 |
|
|
|
|
2 |
284 |
|
|
Macro not running by
Grey Old Man[_2_]
I have recorded a macro in an Excel 2002 template, created a Custom Menu
Item, and assigned the macro name to it.
When I open the template (which creates the...
|
|
1 |
240 |
|
|
filter non-blanks before closing by
Kevin_apprentice
hello!
could anyone help me with my problem?
the case is, I want to auto filter the non-blanks of a column (i.e. "A3")
and save it before I close the...
|
|
1 |
207 |
|
|
make 2003 default version by
Sheahan
After I installed Excel 2003 on my machine, our IT guy also installed Excel
2007. Unfortunately 2007 now wants to be the 'default' version when I export...
|
|
3 |
233 |
|
|
|
|
3 |
303 |
|
|
How to maximize the Excel window? by
Eric
Does anyone have any suggestions on how to maximize teh excel window whenever
I open excel?
I have set Excel application's property into maximizing window,...
|
|
9 |
269 |
|
|
|
May 7th, 2010 01:01 PM
by John
|
6 |
278 |
|
|
|
May 7th, 2010 11:00 AM
by vinu
|
2 |
210 |
|
|
OLAP Pivot Table by
Carissa
I have several pivot tables connected to an OLAP cube. However, the server
hosting our cube has been migrated to a new location. So I need to re-direct
my...
|
|
1 |
265 |
|
|
changing cell reference via another cell by
chicolini
I have a spreadsheet with a tab (called calc) containing columns of
calculations. The next tab (called D) contains a diagram which pulls numbers
off of...
|
|
3 |
256 |