|
|
Pivot Table-Running Total by
rushdhih
Hello,
I have created a Project Finance Reporting Tool, which is based on Pivot
Table. The Source data has several fields in addition to the ones below. I...
|
|
0 |
79 |
|
|
Reference shows zero by
TommyD
Hi,
I have a cell reference in cell B1 (=A1).
If A1 is empty B1 shows "0". Why isn't B1 empty if A1 is?
Both cells have format General.
/Tommy
|
February 4th, 2010 08:43 AM
by TommyD
|
5 |
117 |
|
|
Vlookup across 3 worksheets by
Ben
Hi,
I know there are probably a 100 answer's already posted about this but I
can't get one to match. I have a Vlookup formula that i can get to work
looking...
|
|
2 |
113 |
|
|
|
February 4th, 2010 05:48 AM
by MGC
|
0 |
116 |
|
|
Delete duplicates by
Angie M.
Hi, I have a list of numbers that contain lots of duplicates like the
following:
133150
133150
133150
133154
133154
133154
133155
|
|
4 |
179 |
|
|
Extract emails from cells with text by
AJexcelQuestions
I have a row in column A which includes an email address in the text that I'd
like to extract to column B. Is there a formula I can use to accomplish...
|
|
3 |
101 |
|
|
vlookup issue by
Connor Doyle
Folks,
Sorry if I'm phrasing this wrong, but I've got a vlookup issue that is
returning me N/A values. Here goes:
The lookup value is a cell which contains...
|
February 4th, 2010 02:52 AM
by Pete_UK
|
2 |
82 |
|
|
|
February 4th, 2010 02:08 AM
by Marina
|
0 |
82 |
|
|
Duplicate Function Help by
akemeny
I'm trying to use a duplicate function (or possibly a duplicate macro) to
filter through information.
I've tried =countif($A$1:$A$2000,a2) to locate which...
|
February 4th, 2010 01:47 AM
by Pete_UK
|
1 |
85 |
|
|
|
February 4th, 2010 01:42 AM
by Pete_UK
|
1 |
113 |
|
|
|
|
4 |
107 |
|
|
match and sort two different tables by
yowzers
Column A has customer name, columns B,C,D has corresponding sales data for
that month. Column E is blank. Column F has has customer name. Column
G,H,I has...
|
February 3rd, 2010 11:47 PM
by yowzers
|
2 |
142 |
|
|
|
|
1 |
93 |
|
|
If statement by
Donna
I need a formula that will help me produce the correct answer in this
scenario: If Revised forecast is 0 then Forecast - Actual, if Revised
Forecast is 0...
|
February 3rd, 2010 10:24 PM
by Donna
|
3 |
91 |
|
|
Finding pairs of numbers by
Iriemon
Is this possible? I assume this will involve some VB coding also:
Part Num Associated Part Num
123 456
789 5623
8521 6352
456 123
5478 9821
444444 ...
|
February 3rd, 2010 10:20 PM
by Iriemon
|
2 |
130 |
|
|
Column total is wrong by
Carolan
I have a column of figures which is the result of multiplied column A x
Column B. Column B is a multiplier of .001665. The result is shown to two
decimal...
|
|
5 |
102 |
|
|
Conditional Format Tracker by Date by
Dax Arroway
I'm building a tracker to make sure paperwork is done on time.
Headers:
A:Name
B:IDNum
C:Phone
D:StartDate
E:Plan
F:Paperwork
G:30DAuth
H:90DAuth
|
|
0 |
84 |
|
|
|
|
1 |
121 |
|
|
Using paste link by
daniesmiley
I'm tyring to sort out a spreadsheet that was previously made by someone else
that I'm required to use. The parent spreadsheet that has collaberated info...
|
|
1 |
114 |
|
|
|
February 3rd, 2010 08:50 PM
by Kristin
|
4 |
117 |