Microsoft Office Tutorials and References
In Depth Information
Important Tools for Any Business
Because of the complexity of this setup, I would suggest referring to the CD. This example
actually tells you when you need to start a project based on a completion date with the following
variables: Weekly Average, Total Output or Units, and Capacity to Deliver per phase.
Figure 2.33
This formula operates
off of a given
completion date and three
variables to tell you
when to start
production based on a
sixweek ramp up time to
100% production.
Counting Unique Items in a List
You can count unique items in a list with these two formulas. Yes, you could filter the list
with unique items only, however, if your list is quite large, you’ll still need to count the
items. Notice Figure 2.34. The first array formula counts the unique items in a list with
{=SUM(1/COUNTIF(D4:D10,D4:D10))} , however, if there is a blank cell the result is #DIV/0! .
To circumvent this problem, the following formula will return the unique items in a list
regardless of the blank cells.
Figure 2.34
Return the number of
unique items in a list
with these two formulas.
Search JabSto ::




Custom Search