Formula to count unique values

[uAnonimo]

Hello.I've tried to Google it, but the formulas I've found are kinda of complex, I couldn't create my own version of them

I have a list of tasks that have indicators, I would like a formula to count all the times that an indicator appear in a task, but without counting the duplicated lines.

The formula would give me, how many G1,G2 and G3 unique tasks I have in the list.Here's the layout:

---

TASKS	INDICATOR		NUMBER OF UNIQUE TASKS = G1	2
TASK ONE	G1		NUMBER OF UNIQUE TASKS = G2	2
TASK ONE	G1		NUMBER OF UNIQUE TASKS = G3	1
TASK ONE	G1
TASK TWO	G2
TASK TWO	G2
TASK THREE	G2
TASK THREE	G2
TASK FOUR	G1
TASK FOUR	G1
TASK FIVE	G3
TASK FIVE	G3
TASK FIVE	G3

<tbody>
</tbody>

---

 

[ClintMc]

I think the simplest way is to use a COUNTIF function.

COUNTIF(B2:B12,"G1")

 

[ClintMc]

Nevermind, read your question closer. Let me think about that...

 

[AhoyNC]

Try:
This is an array formula that must be entered with CTRL-SHIFT-ENTER.
Drag formula down column as needed.

Excel Workbook
	A	B	C	D	E	F
1	TASKS	INDICATOR		Count	G1	2
2	TASK ONE	G1			G2	2
3	TASK ONE	G1			G3	1
4	TASK ONE	G1
5	TASK TWO	G2
6	TASK TWO	G2
7	TASK THREE	G2
8	TASK THREE	G2
9	TASK FOUR	G1
10	TASK FOUR	G1
11	TASK FIVE	G3
12	TASK FIVE	G3
13	TASK FIVE	G3
Sheet

 

[uAnonimo]

Try:

I've spent the entire day trying to accomplish that LOL
Thank you, mister hacker!

 

[AhoyNC]

You're welcome. Thanks for the feedback.