Pulling cell data for all duplicate values

[tara_922]

Hiya all!

Another question.

I have a column that counts column G and highlights duplicate values. Now I would like to have the next column pull all the dates for the duplicate values.

So, we're talking about parking tickets here. Column G has the license plate #. Column A has the date of the ticket. Column M has the duplicate values highlighted. How do I pull all the dates from column A into Column N so I can easily tell what dates each ticket was received. If possible I would like to convert the date into day format. This is to help us see if there is the same car parking every friday at our resort for local events and not as a guest of the resort.

Thanks for everything. You all are truly amazing!

Tara

 

[tara_922]

Yes! That's exactly right! In the corresponding cell in column N. Now we're cooking with gas!

Tara

 

[Just Jan]

N1 is plate to check
N2 =IF(ROWS($1:1)>MAX(O:O),"",INDEX(A:A,MATCH(ROWS($1:1),O:O,0))) copy down a few rows format as long date
O2 =O1+IF(G2=$N$1,1,0) copy down to match column G (leave O1 blank)

 

[Manohar M G]

Hi..

Ya.. we are almost there to cook with gas...

Column A Column B Column N
5/11/2011 A602ZB 4 05/11,05/22,05/26,06/09
5/22/2011 A602ZB 4 05/11,05/22,05/26,06/09
5/26/2011 A602ZB 4 05/11,05/22,05/26,06/09
6/9/2011 A602ZB 4 05/11,05/22,05/26,06/09

This is right what you want...??? if it right we will obviously cook with gas...

 

[tara_922]

Yup!

 

[Manohar M G]

Hi...

k... finally we cook the gas.. we will see the output.. hw it s...???