Hi, and apologies for joining and getting straight in with a 'help' request ... but I'm baffled.
I have a list (about 6000 rows) of numbers. Each number appears between once and 20 times. I'd like to identify the numbers that appear only once. I think I need to use the Frequency function but I'm struggling with understanding it.
I'd appreciate any help to:
a) suggest another way of identifying numbers that only appear once
b) understand the Frequency function to resolve my problem.
Just to be clear, as a small example...
2
5
5
7
7
7
8
I only want to be able to find those that appear once (the 2 & 8)
Thanks in advance
Bookmarks