R
Ronan
Hi, is there a way of returning the list of unique records from a list of
data. For example, my list could contain 1, 1, 2, 3, 1, 2, 9, 1, 4, 5, 4, 4,
3, 2, 3, etc... I know I can use the frequency function but my list has over
2000 entries and I dont know what the actual unique list of numbers is in
order to use the frequency function. I could also use a pivot table but was
hoping to use some formula or formulae.
Hope this makes sense
Thanks.
data. For example, my list could contain 1, 1, 2, 3, 1, 2, 9, 1, 4, 5, 4, 4,
3, 2, 3, etc... I know I can use the frequency function but my list has over
2000 entries and I dont know what the actual unique list of numbers is in
order to use the frequency function. I could also use a pivot table but was
hoping to use some formula or formulae.
Hope this makes sense
Thanks.