On 2002-03-18 13:41, Lewy2 wrote:
I have a column that has text entered into it
like the following.
1-1
1-1
1-2
1-3
1-4
1-4
I want to be able to count the number of sets that occur more than once.
ie the above would have aresult of 2 being 1-1 & 1-4
I cant Get either of the relies to work thanks for the effortOn 2002-03-18 14:03, Aladin Akyurek wrote:
On 2002-03-18 13:41, Lewy2 wrote:
I have a column that has text entered into it
like the following.
1-1
1-1
1-2
1-3
1-4
1-4
I want to be able to count the number of sets that occur more than once.
ie the above would have aresult of 2 being 1-1 & 1-4
=SUM(IF(FREQUENCY(MATCH(A2:A7,A2:A7,0),MATCH(A2:A7,A2:A7,0))>1,1))
where A2:a7 houses the sample you provided.