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 :
[TABLE="width: 647"]
<tbody>[TR]
[TD]Data1[/TD]
[TD]Data2[/TD]
[TD][/TD]
[TD][/TD]
[TD]Results[/TD]
[TD]No. Of Unique Values in Data 2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]f720298[/TD]
[TD="align: right"]3608866336[/TD]
[TD][/TD]
[TD][/TD]
[TD]f720298[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]f722942[/TD]
[TD="align: right"]9897888929[/TD]
[TD][/TD]
[TD][/TD]
[TD]f722942[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]f724251[/TD]
[TD="align: right"]3501430051[/TD]
[TD][/TD]
[TD][/TD]
[TD]f724251[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]f724251[/TD]
[TD="align: right"]3501430051[/TD]
[TD][/TD]
[TD][/TD]
[TD]f807531[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]f724251[/TD]
[TD="align: right"]9897888929[/TD]
[TD][/TD]
[TD][/TD]
[TD]g341351[/TD]
[TD] 1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]f807531[/TD]
[TD="align: right"]1867781528[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]g341351[/TD]
[TD="align: right"]1867781528[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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