Urgent Excel Help Sought . . . .
#1
Moderator
Thread Starter
iTrader: (5)
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes
on
0 Posts
Urgent Excel Help Sought . . . .
Hello all,
I have a little poser which I need to urgently solve !!
I have a list of values in column A, these values may appear more than once in the list. What I need, is a list of the values that appear more than once.
Obviously, I can use a filter with unique values that shows the unique list, but this does not give the flipside. Refering to the example, the resulting list would be "hello" as this appears more than once.
Any ideas ?
Regards,
Dunk
I have a little poser which I need to urgently solve !!
I have a list of values in column A, these values may appear more than once in the list. What I need, is a list of the values that appear more than once.
Code:
EG: A B C 1 hello 2 goodbye 3 adios 4 hello 5 au revoir
Any ideas ?
Regards,
Dunk
#4
Moderator
Thread Starter
iTrader: (5)
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes
on
0 Posts
Nobody seemed to be interested when I posted
Similar . . . . I used:
=COUNTIF($A$1:$A$5,A1)
This results in a count next to each value that appears more than once. Copy and paste values, then sort by the resulting values. Anything with a 1 can be excluded and the remainders appear more than once in the list.
Similar . . . . I used:
=COUNTIF($A$1:$A$5,A1)
This results in a count next to each value that appears more than once. Copy and paste values, then sort by the resulting values. Anything with a 1 can be excluded and the remainders appear more than once in the list.
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
bluebullet29
General Technical
9
05 October 2015 02:17 PM