|
|
|
|
0 |
487 |
|
|
|
|
0 |
502 |
|
|
|
|
0 |
499 |
|
|
|
|
0 |
485 |
|
|
|
|
0 |
513 |
|
|
|
|
0 |
521 |
|
|
|
|
0 |
502 |
|
|
|
|
0 |
471 |
|
|
|
|
0 |
497 |
|
|
|
|
0 |
465 |
|
|
|
|
0 |
459 |
|
|
|
|
0 |
530 |
|
|
|
|
0 |
480 |
|
|
|
|
0 |
639 |
|
|
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 |
364 |
|
|
|
March 17th, 2005 10:40 PM
by Biff
|
2 |
487 |
|
|
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 |
303 |
|
|
How many in column by
Hi
Try something like this:
=COUNTIF(A2:A2000,"White")
--
Andy.
"Ralph Smith" wrote in...
|
|
4 |
273 |
|
|
|
|
4 |
294 |
|
|
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 |
524 |