|
|
|
|
10 |
1,257 |
|
|
Find second to last value in cell by
Eric_G
Unless most "right" or "left" functions in which one is looking to select the
"LAST" or the "FIRST" value within a string of characters within a call, I
wish...
|
|
4 |
358 |
|
|
|
|
5 |
392 |
|
|
Sumproduct with mixed data? by
gooders
Hi, I have a column that is predominately filled with dates i.e. 1/12/2010;
16/4/2010 etc, and my formula below counted the number of rows based upon the...
|
|
6 |
320 |
|
|
|
|
4 |
280 |
|
|
Percentages in Pivotal by
JoeM
I have a pivot table I want to do percentage of total on:
Column 1 Column2
Ice Cream 32
Cake 50
Total 82
I want to...
|
|
3 |
275 |
|
|
How do I use a percentage formula? by
MeursaultO
Currently I am working on an assignment and need to turn a whole column
(approx. 153 cells) into a individual percentages of one cell. Every time I
tried...
|
|
3 |
291 |
|
|
|
|
3 |
261 |
|
|
how to remove all formatting by
Tom
I am working on office 2007 prof - my spreadsheet should be read by
colleagues using 2003 and ideally 2000 versions.
While I was able to save the file as xls...
( 1 2)
|
|
14 |
556 |
|
|
Drill down via page fields by
Roland Grothe
I'm quite new to Pivot-Charts, so i need some help.
I use a quite simple table with Employees, segments, OrderValue, Date (only
months) and products. Every...
|
|
1 |
263 |
|
|
|
|
0 |
292 |
|
|
VLOOKUP in VBA by
G.P.N.L. c.v.a.
I am a beginner in VBA; nevertheless, I already have several working UDF's
in Excel 2003, though.
Why does TGI(A213) gives me "#VALUE!"
- while A213 contains...
|
|
7 |
245 |
|
|
Rounding Seconds in 4/21/2010 4:30:23 PM by
Tom Langley[_2_]
I am trying to round the seconds portion of a column of cells containing both
date and time.
Currently the cells contains:
4/21/2010 4:30:23 PM
4/21/2010...
|
|
5 |
215 |
|
|
|
|
6 |
206 |
|
|
Excel formula help needed! by
Pat Convey
Hello everyone,
I would like to create a formula that would calculate a different levy
charge dependent on the amount.
The example is below and any help...
|
|
3 |
281 |
|
|
Cells Are Not Updating by
PA Valley
All of a sudden the formulas in a cell are not updating. I have read the
posts rid the fix and nothing happens. Only by going to the cell, clicking on
the...
|
|
2 |
222 |
|
|
|
|
6 |
337 |
|
|
Format Data Labels by
ela
In Excel 2007 pie chart, there is an option called "format data labels" to
let you determine what types of information to show.
Unfortunately, whenever you...
|
April 24th, 2010 03:20 PM
by ela
|
0 |
197 |
|
|
Formulas not updating by
Creating a Database in VWD
Hi,
I am copying my sheets and changing there names. For instance, I have sheets
in this order:
May 1 - Day and May 1 - Night. May 1 - Night has formula...
|
|
2 |
199 |
|
|
Saving & Removing VB Code from WB by
NoodNutt
Hi everyone
1. I'm looking for something in VB that will save a copy of my workbook "in
the background" to another location on a network drive.
2. During...
|
|
4 |
195 |