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