|
|
PivotTable/Chart - Statistics (Excel 2007) by
Kim Glensor
Hi,
I've never actively used PivotTables or PivotCharts before, but have
something very specific I want to try and do - hoping I could get pointed in
the...
|
|
1 |
95 |
|
|
% Change in reverse (algebra) by
andy
The starting value is 1000. If it is up 5% it would equal 1050. If I still
want to keep my starting value in B4 what equation would I use to find the
value...
|
|
1 |
122 |
|
|
|
|
2 |
114 |
|
|
#NUM! by
Connie Martin
This is exhausting. I've surfed and surfed for answers. None! I have a
previous post, just two or three down from this one ("Need help with
formula), but...
|
|
1 |
105 |
|
|
|
|
0 |
174 |
|
|
copying formulas by
ambam
Probably a very simple question but... i use excel for bookkeeping and
therefore have sheets of jan to dec with formulas in certain cells to work
out VAT...
|
|
7 |
152 |
|
|
Calculate pivot table items in 2007 by
Dianeg
I have created a sum using getpivotdata to add 2 items in a pivot table. The
first one works fine but when I try to copy it down the column, I get the
same...
|
January 13th, 2010 09:01 PM
by Dianeg
|
2 |
140 |
|
|
|
|
1 |
173 |
|
|
|
|
1 |
127 |
|
|
|
|
4 |
113 |
|
|
How do I add the formula bar? by
tysiesmoma
I've recently switched computers and now my Microsoft Excel does not display
the formula bar at the top of the page. It is much easier to edit long
formulas...
|
|
2 |
109 |
|
|
summary by
JD
Any help with the following is much appreciated. I have a set of data with
unique ID numbers. There are multiple entries for each Unique ID with
different...
|
January 13th, 2010 06:40 PM
by Luke M
|
1 |
69 |
|
|
convert time to decimal by
doodle302
I'm looking for a formula to convert time to a decimal
Example: (6:15 + 5:45 + 2:15 + 1:25) * 3 = equals amount due in dollars
(whole number)
times listed...
|
|
2 |
92 |
|
|
|
|
7 |
76 |
|
|
Macro code behind button by
bcm2
How do I find out what macro and the code assigned to a specific button in an
Excel worksheet? I can view all the macros assigned to the workbook, but it...
|
January 13th, 2010 06:13 PM
by Luke M
|
1 |
88 |
|
|
Copy or Move by
Fareez
Dear All
I have lot of work sheets in one excel work book , i want all work sheet in
one sheet. is there any possiblities to move all sheet to one sheet...
|
|
3 |
94 |
|
|
COUNTIF for date and amount by
Outlook, eh?[_2_]
I am looking for a function to find money values within certain ranges and
within certain date ranges:
Here is what the data I will get will look like
A ...
|
|
1 |
89 |
|
|
cell displays 0 when formula is valid by
jto
I have a VLOOKUP. The wizard box shows the formula result but it appears as
"0" in the cell. Formatting is general. Why doesn't the result display in
the...
|
January 13th, 2010 05:34 PM
by jto
|
2 |
93 |
|
|
Dynamic Range for Offset by
VBApprentice :)
Dear Gurus,
Trying to change the Reference Cell of the Offset funtion, but
unfortunately, can not succeed in doing so. For example,
1 2
A 100 ...
|
|
8 |
108 |
|
|
Strange Function Copy by
msnyc07
I created a simple Concatenate Function
C2, " ", D2, " ", E2
Which worked e.g.
Big Red Apple
I filled that down
|
|
1 |
146 |