Count unique occurences for per ID for multiple ID

In sheet1 I have several rows with the same identifier. I want to count up the number of unique occurrences in a range for each id.

e.g. Sheet1

A B C D E

1 ID_1 PRD LFT TGB DEC

2 ID_1 DEC STF PRD ABG

3 ID_1 DEC PRD ABG LFT

4 ID_2 PRD LYU TGB DEC

5 ID_2 PRD TFL TGB DEC


I would like to produce a summary in a separate sheet or area on sheet1 to look like:


A B C D E

1 PRD 2 (the number is 2 as PRD is unique once for each ID_x)

2 LFT 1 (the number is 1 as LFT is unique once for each ID_1, doesnt appear for ID_2)

Will try and let you know
Thanks

The code is almost working as expected.
I am getting the count of 1 for every value in the results.
i.e.
A B C D E
1 PRD 1
2 LFT 1
3 TGB 1
4 DEC 1

Thanks so far

I am attaching a snip of the actual file I am using with your code that has been addapted accordingly.
I assume it must be something I have broken.

What have I done wrong?

Hi,
Managed to get it to work, THANKS!
Saved my day!