Formula to solve a question

[Nelboy]

Good Morning is it possible to answer the following question without creating a data list (to reference in a countif formula)

I have a range of data in column A of Worksheet 1

1
1
1
2
2
2
5
5
5
and so on

The question states which number is represented 10 times.

i can work out the answer simply by copying the data to a new sheet (removing duplicates and then doing a countif formula) this seems to very long winded so wondered if it is possible to work out the answer in a single formula

I look forward to your responses.

thanks in advance

andrew

 

[steve the fish]

This requires CTRL-SHIFT-ENTER entry:

=INDEX(A1:A100,MATCH(10,COUNTIF(A1:A100,A1:A100),0))

 

[Nelboy]

Thanks very much

This requires CTRL-SHIFT-ENTER entry:

=INDEX(A1:A100,MATCH(10,COUNTIF(A1:A100,A1:A100),0))