On Apr 14, 3:44*am, "T. Valko" wrote:
Assume:

A2:A10 = Week
B2:B10 = Task

D2:D3 = Painting; Drawing

If there are no empty cells within Week, try this arry formula** :

=COUNT(1/FREQUENCY(IF(Task=D2,Week),Week))

If there might be empty cells within Week, use this version** :

=COUNT(1/FREQUENCY(IF((Task=D2)*(Week<""),Week),Week))

Copy down to D3.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP

wrote in message

...



Hi,

Can anyone help me please.
I have a spreadsheet and I am trying to calculate how many weeks a
task took to complete.
The task does not necessairly have to be completed in consecutive
order.

A brief example:

Week * Task
1 * * * * *Painting
1 * * * * *Painting
1 * * * * *Drawing
2 * * * * *Drawing
2 * * * * *Drawing
2 * * * * *Drawing
3 * * * * *Painting
3 * * * * *Drawing
3 * * * * *Drawing

From the table the Painting task was completed in 2 weeks and the
Drawing task was completed in 3 weeks.

I would appreciate your help.- Hide quoted text -

- Show quoted text -

Thanks everyone!
You are lifesavers!
Biff's worked the best!