|
|
|
|
0 |
504 |
|
|
|
|
0 |
516 |
|
|
|
|
0 |
512 |
|
|
|
|
0 |
498 |
|
|
|
|
0 |
534 |
|
|
|
|
0 |
537 |
|
|
|
|
0 |
519 |
|
|
|
|
0 |
484 |
|
|
|
|
0 |
515 |
|
|
|
|
0 |
481 |
|
|
|
|
0 |
471 |
|
|
|
|
0 |
542 |
|
|
|
|
0 |
497 |
|
|
|
|
0 |
662 |
|
|
Fiscal year total from running 12 months by
I maintain data for the previous twelve months in Excel 2002. I want to
calculate statistics based on fiscal year data, which is a changing subset
of the...
|
February 9th, 2005 12:11 AM
by
|
2 |
369 |
|
|
|
March 17th, 2005 10:40 PM
by Biff
|
2 |
490 |
|
|
Hiding zeroes in Office 2002 by
Hi
My mate uses Excel 2002. I've talked him through setting up a few formulae,
one of which is like this:
=IF(A2="",0,VLOOKUP(A2,F:H,2,FALSE))
When A2 is...
|
May 23rd, 2005 04:24 PM
by
|
3 |
306 |
|
|
How many in column by
Hi
Try something like this:
=COUNTIF(A2:A2000,"White")
--
Andy.
"Ralph Smith" wrote in...
|
|
4 |
275 |
|
|
|
|
4 |
298 |
|
|
Help with array formula by
Hello friends,
I believe that the solution to my problem lies in the
writing of an array formula; but since my creativity with
writing array formula is very...
|
January 20th, 2005 04:17 PM
by
|
2 |
532 |