#### dgexcellent

##### New Member

- Joined
- Nov 5, 2012

- Messages
- 20

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 :

<tbody>

</tbody>

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>

Last edited: