|
|
Problem with Syntax? by
MurrayBarn
2 B C D E
3 PolicyStartDate Class ClassTotal VAT
4 01/11/2008 Motor 10,039.24 1,232.89
5 01/11/2008 Motor -200.00 ...
|
|
8 |
176 |
|
|
Go to a chosen worksheet by
Bob[_53_]
I am trying to create a simple index page as the first sheet in
workbook.
The book has over 20 worksheets in it. On sheet1 I would like to have
a dropdown...
|
|
1 |
175 |
|
|
macro to grab current workbook filename by
TR Young
Excel 2003:
I need a macro that grabs the current workbook filename and drops it into
cell A2. I know this is simple, but my head is fried this evening....
|
June 12th, 2009 12:41 PM
by Eduardo
|
3 |
214 |
|
|
|
|
1 |
118 |
|
|
Filter in Rows not columns by
Russell
I would like to be able to apply a filter (an autofilter) down a column, so
that I can filter certain columns. Rather than use the convenstional method
of...
|
June 12th, 2009 10:02 AM
by Russell
|
3 |
236 |
|
|
|
|
4 |
164 |
|
|
Countif cell is conditionally formatted by
RicG
Each row of a table is conditionally formatted to show the largest number in
the row. I would like to count the total number of highlighted cells in each...
|
|
1 |
121 |
|
|
Hiding columns in Excel 2003 by
Les
Hi,
I do know how to hide columns but I have a problem. Say I have a worksheet
which person A uses columns A through T. I plan on using columns AA and AB...
|
|
2 |
134 |
|
|
inverse weighted average by
Harlan Grove[_2_]
Dan Cotts wrote...
I am trying to figure out how to do a weighted average using a reverse ratio
- that is, I have...
|
|
0 |
153 |
|
|
Inverse wieghted average/ratio by
dtacotts
I am trying to figure out how to do a weighted average using a reverse ratio
- that is, I have members of a group, each with Income, that I need to
allocate...
|
|
1 |
113 |
|
|
Sums including #NAME? by
Fred Holmes
Excel 2000
How do I get a SUM() formula to ignore (disregard) any #NAME? errors
in the range being summed, and produce (evaluate to) the sum of the
valid...
|
|
2 |
117 |
|
|
|
|
9 |
192 |
|
|
Remove last n rows by
Colin Hayes
HI
I have an excel problem I hope someone can help with.
I need a small macro which , via popup , will allow me to remove the
last n rows of a...
|
|
6 |
114 |
|
|
|
June 12th, 2009 02:17 AM
by smartin
|
3 |
147 |
|
|
Sort Block of Data by
lab-guy
Hi All -
I have a large block of data, 25 x 25.
(classes going down, students going across)
At the intersection, I have a concatenate formula grabbing...
|
June 12th, 2009 12:46 AM
by CLR
|
3 |
127 |
|
|
How to import PDF into Excel? by
JoeU2004
I want to import some data from PDF files into Excel. Is there a
straight-forward way to do this?
For example, see...
|
|
1 |
170 |
|
|
Sumproduct with blanks by
EZ[_2_]
I have been using SUMPRODUCT for a while, and so far it's great. I'm trying
to use it on data range with blanks. My data is arranged as 52 weeks/rows for...
( 1 2)
|
June 11th, 2009 11:55 PM
by EZ[_2_]
|
10 |
211 |
|
|
Eliminating Duplicates in Excel 2007 by
Té
I have a customer name (Tina) and numbers that go with Tina's information
(575, 125, and 700). How can I find the highest number, and delete the other...
|
June 11th, 2009 11:19 PM
by Té
|
2 |
128 |
|
|
|
|
1 |
123 |
|
|
|
|
2 |
131 |