|
|
|
|
0 |
503 |
|
|
|
|
0 |
513 |
|
|
|
|
0 |
510 |
|
|
|
|
0 |
497 |
|
|
|
|
0 |
530 |
|
|
|
|
0 |
535 |
|
|
|
|
0 |
517 |
|
|
|
|
0 |
483 |
|
|
|
|
0 |
513 |
|
|
|
|
0 |
478 |
|
|
|
|
0 |
469 |
|
|
|
|
0 |
541 |
|
|
|
|
0 |
495 |
|
|
|
|
0 |
659 |
|
|
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 |
297 |
|
|
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 |
531 |