|
|
|
|
0 |
512 |
|
|
|
|
0 |
525 |
|
|
|
|
0 |
525 |
|
|
|
|
0 |
509 |
|
|
|
|
0 |
542 |
|
|
|
|
0 |
545 |
|
|
|
|
0 |
529 |
|
|
|
|
0 |
491 |
|
|
|
|
0 |
522 |
|
|
|
|
0 |
486 |
|
|
|
|
0 |
478 |
|
|
|
|
0 |
550 |
|
|
|
|
0 |
504 |
|
|
|
|
0 |
672 |
|
|
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 |
371 |
|
|
|
March 17th, 2005 10:40 PM
by Biff
|
2 |
492 |
|
|
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 |
308 |
|
|
How many in column by
Hi
Try something like this:
=COUNTIF(A2:A2000,"White")
--
Andy.
"Ralph Smith" wrote in...
|
|
4 |
278 |
|
|
|
|
4 |
301 |
|
|
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 |
533 |