|
|
Pivot Table and Countif Function by
Amiram
ID B Month
A1 Pass Feb
A1 Pass Feb
A1 Pass Feb
A3 Fail Feb
A4 Fail Feb
A4 Pass Feb
A4 Fail Feb
A4 Pass Feb
A1 Pass Jan
|
November 11th, 2003 03:29 PM
by Amiram
|
0 |
311 |
|
|
excel automatic add-ing by
luis
the automatic add-ing stop working. i uninstalled the program and reinstalled again, but did not fix the problem. I used tthe fix and repair option but did...
|
|
1 |
288 |
|
|
manual calculation doc by
Sheri
A monthly excel report sent from our corporate office to
our remote location is saved by the sender in Manual
calculation. With no other excel documents open,...
|
|
1 |
364 |
|
|
Linking workbooks by
Fawn
I have 4 workbooks with approximately 12 sheets with the information rolling
up into one YTD sheet. What I want to do is to have all 4 of the YTD sheets
on a...
|
|
1 |
349 |
|
|
|
|
1 |
513 |
|
|
Dynamic Range by
Brian
I am trying to create a macro and am stuck trying to
figure out how to determine my last column. In cell E3 I
am using the formula =COUNTIF(E4:??,0). Can I...
|
|
5 |
417 |
|
|
Array Function - cell to remain blank by
mare
I am a novice on Excel, however, I don't get easy projects.
I have a spreadsheet where D6:D15 have values. In cell D17
is the Total, which is an average of...
|
|
1 |
189 |
|
|
|
|
3 |
527 |
|
|
|
November 11th, 2003 10:50 PM
by ken
|
2 |
350 |
|
|
Assign Macro to AxtiveX objects by
Roger Trewenack
Just started playing with ActiveX Command Buttons, with a
view to adding macro code to them to do simple functions
within Excel (Versions 2000 & XP).
According...
|
|
1 |
289 |
|
|
HLookup by
Steve
I am trying to build a template and one of the formulas
that I have to use is HLookup. Is there a way to write
this formula if I don't know what the last row...
|
|
4 |
146 |
|
|
Sorting based on a drop down list by
Randall Roberts
how can i have excel sort a work sheet based on a selection from a
drop down list
The selections in the list would be the same as the headers on the
sheet
|
|
1 |
542 |
|
|
|
|
4 |
410 |
|
|
Copy Unique Records ... Formula? by
Ken
I know I can use "Advanced Filter" to copy Unique Records
to another location of spread sheet. Question is ... can
this be achieved with a formula?
Something...
|
|
5 |
542 |
|
|
|
November 12th, 2003 01:20 AM
by Max
|
2 |
478 |
|
|
|
|
2 |
228 |
|
|
roots by
Murray
Can Excel calculate the root of a number and if so, how
please? For example, what is the 11th root of 500?
Thanks
Murray
|
|
1 |
140 |
|
|
|
November 12th, 2003 08:44 AM
by jale
|
4 |
492 |
|
|
auto SUM a FILTERED List by
davidbrowne17
When using the AUTO filter, is there a forumular to SUM the filtered
list ( i.e Displayed items)
I have used the SUM fuction, this will add up the current...
|
|
1 |
360 |
|
|
|
|
3 |
299 |