|
|
CountIf to determine Date - 3 yrs by
Brent E
Good day,
I have a series of data including a date col. What is the criteria statement
I should use in the CountIf formula to determine the no. of records...
|
|
3 |
146 |
|
|
macros by
Amanda
I am trying to do my Excel homework. And they are asking me to record a
macro. I am unable to record a macro in Excel, but I am able to record one in
Word. I...
|
|
1 |
77 |
|
|
Formulas by
Saadia
I have an excel spreadsheet, where i keep track of how many estimates were
sent out by our estimators, the date it was sent out, approved, started,...
|
|
4 |
168 |
|
|
formulas by
milo
hey i am going a sreadsheet for heat loss calcs but can any one tell me how
to multiply by the power
example: .05^1.3 i tried doing tht in the cells but it...
|
|
3 |
96 |
|
|
|
|
2 |
110 |
|
|
Goal Seek in a Macro by
mrogge2895
I am attampting to write a macro where I use goal seek to solve for price
based on the desired IRR input. When I bring up goal seek, it forces me to...
|
November 20th, 2008 11:37 PM
by galimi
|
1 |
125 |
|
|
|
|
3 |
96 |
|
|
Auto numbering inserted rows. by
Sherrill
I need to have newly inserted rows auto-number upon insertion. I've searched
for any tips and the closest I can find is the List function on the Data
menu,...
|
|
1 |
93 |
|
|
Save Pivot Table Format in 2007 by
Joyce
In Excel 2003 you could save a Pivot table format and apply other worksheets
to it, can you do that in 2007? If so how?
|
November 20th, 2008 11:12 PM
by Joyce
|
2 |
104 |
|
|
|
November 20th, 2008 11:05 PM
by Joyce
|
0 |
94 |
|
|
Printing UserForms by
leerem
I have produced several reports which is displayed on a Userforms named
Reports1 - Reports7, is it possible to then print these report individually
as a...
|
November 20th, 2008 10:35 PM
by Wigi
|
1 |
78 |
|
|
Dispaly results, rather than a formula by
Donna
I have several worksheets in a file. The first worksheet is what i call
"H"... i enter pertinent info that will be used in other worksheets... things
like...
|
November 20th, 2008 10:18 PM
by Donna
|
2 |
77 |
|
|
Cell format problem by
Carey
I am doing pivot table reports in Excel 2002, and the there are several
numbers that are not sorting in numerical order. Instead they appear at the
top of...
|
November 20th, 2008 10:18 PM
by Carey
|
2 |
68 |
|
|
Save changes? even when you've made none by
Donna
Everytime I close a certain file, it always asks me if I want to save
changes, even though I didn't do anything. I just opened the file, looked
at, then...
|
November 20th, 2008 10:17 PM
by Donna
|
3 |
79 |
|
|
|
November 20th, 2008 10:09 PM
by Marge
|
2 |
90 |
|
|
odd behavior by
Rich[_20_]
Hi,
I have a problem with a particular workbook I'm building. If I try to amend
a formala, instead of the result, the formalu is visible in the cell, and no...
|
|
2 |
81 |
|
|
Comparing information on 2 worksheets by
Lee
I am trying to compare certain information on 2 different worksheet to make
sure both are listed. Is there an easy way to do this. Possible turn the
cells...
|
November 20th, 2008 09:57 PM
by Luke M
|
1 |
71 |
|
|
Dynamic Chart Question by
DoubleZ
In Excel 2007 I have created a dynamic chart. The data is working out just
fine, however the horizontal axis labels are not correct. For instance, in
one...
|
November 20th, 2008 09:51 PM
by DoubleZ
|
0 |
110 |
|
|
count / match by
Rachel
Hi,
Column A Column B
John = return value of 1, if matches, else 2
John
Smith
Bob
I like to have a formula in column b, if item in A1, "John" matches
|
November 20th, 2008 09:33 PM
by T. Valko
|
1 |
88 |
|
|
Filtered Counting by
Rob
Hello I found an excellent formula to count unique values in a given column
and it even modifies the count when they are filtered. Here's the formula I
am...
|
November 20th, 2008 09:27 PM
by T. Valko
|
5 |
95 |