Count recurring value and show the dates

[Jeffreyxx01]

Hi all,

I am trying to work out some data analysis on a currency pair.
I wanted to get the date for the same value that occurs 2 times or more.

I have counted in my files value that occurs 2 times: 78 times and value that occurs 3 times: 12 times.
But I cannot work out a formula that show me for the dates for the 78 value.

For example I have 0.6111 that occurs twice, once on 29/02/2000 and 01/04/2002.
What I would like to work out is a formula that shows me both dates.

If anyone can help, that would be good.

Thanks a lot

Jeffrey

 

[Jeffreyxx01]

Hi Aladin

The expected output that I look for is:

for the given data:0.6111, I want to see both given date such as for example: 29/02/2000 and 30/06/2005

If you have an idea how to get it, that would be perfect.

 

[Aladin Akyurek]

Hi Aladin

The expected output that I look for is:

for the given data:0.6111, I want to see both given date such as for example: 29/02/2000 and 30/06/2005

If you have an idea how to get it, that would be perfect.

I do see that there is one occurrence of 0.6111 which is associated with 29.02/2000. But I don't see 30/06/2005 in the sample of post #6 . Any comments?

 

[Jeffreyxx01]

There is 400 data on my Excel and I was not going to put them all. I just gave 10 first data. That is why you just see that.

 

[Aladin Akyurek]

There is 400 data on my Excel and I was not going to put them all. I just gave 10 first data. That is why you just see that.

Care to post an illustrative sample for which you can indicate the output you require?