Hi All, I was wondering if you could help,
id like to only return a instance where they may be multiple duplicates
So on sheet1 column A may look like
84946
84946
84946
84946
84946
82740
82740
82740
82740
74063
74063
74063
74063
What id like to happen is sheet 2 column A would show
84946
82740
74063
is this possible with a formula.
Bookmarks