Counting unique values with multiple arguments

[dgexcellent]

Hi, I have a 900+ line data set like the below. What I need is a formula that counts the number of unique occurrences in the second column in reference to the first. This value would then be referenced into a second table using the unique values of the first.

So I'm after two formulas :
create a list of the unique values from Data1 (having this auto-sorted numerically would be fantastic but not vital)
count the number of unique values in Data2.

Thanks greatly in advance,

Dave

Data and intended Results look like :

Data1	Data2			Results	No. Of Unique Values in Data 2
f720298	3608866336			f720298	1
f722942	9897888929			f722942	1
f724251	3501430051			f724251	2
f724251	3501430051			f807531	1
f724251	9897888929			g341351	1
f807531	1867781528
g341351	1867781528

<tbody>
</tbody>

 

[Aladin Akyurek]

i didnt understand his question

No problem. Happens often to all of us...

thank you, I didnt know that it was so bad on performance

You are welcome.

 

[dgexcellent]

Thanks to everyone, this has now solved an inter-departmental war and for the first time created solid reporting on a months old KPI .

I love this community of learning and continual improvement.

 

[Akashwani]

Hi Dave,

I'm pleased you have resolved this and thanks for the feedback.

You know where to come for all your Excel problems, see you again soon

Ak