Pivot or Macro Show result

[Antonio12]

Hello everybody:

I have a question regarding a formula that I can´t get right. I want to do a macro for this but I think a pivot would be easier so I'm asking for your help.

I have a big DB with several rows and columns.

Column B has several card numbers (e.i. 7987654345678)
Column C has a location name (e.i. madrid)
Column L has a date (the date is when the card was used)

What I want to do is identify the cards that appear more then twice on the same date and the same place.


E.I.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Card Nuumber[/TD]
[TD]Location[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]123
[/TD]
[TD]LOC[/TD]
[TD]18/01/2013[/TD]
[/TR]
[TR]
[TD]321[/TD]
[TD]MAD[/TD]
[TD]17/01/2013[/TD]
[/TR]
[TR]
[TD]234[/TD]
[TD]CAS[/TD]
[TD]01/02/2013[/TD]
[/TR]
[TR]
[TD]234[/TD]
[TD]CAS[/TD]
[TD]16/02/2013[/TD]
[/TR]
[TR]
[TD]234[/TD]
[TD]CAS[/TD]
[TD]16/02/2013[/TD]
[/TR]
</tbody>[/TABLE]

I would like through a macro or pivot to show me the results of the 2 last rows, because those are the only ones that are exactly the same.

I know this can be done in a Pivot (don´t know how though) and I'm wondering how to do this but I'm also wondering if this could run from a userform or if from the userform I could click on a commandbutton that would bring up the pivot with the results.

PLEASE HELP!!!

I have excel 2007 running on Windows7

 

[Andrew Poulsom]

Create a pivot table from your data with Card Number, Location and Date as Row fields and Count of Date as the Data field. Turn off Subtotals and Grand Totals and set the Report Layout to Tabular Form. Then apply a Value Filter to the Date field with the condition Count of date is greater than 1.

Result:

Excel 2010
	A	B	C	D	E	F	G	H
1	Card Number	Location	Date		Card Number	Location	Date	Count of Date
2	123	LOC	18/01/2013		234	CAS	16/02/2013	2
3	321	MAD	17/01/2013
4	234	CAS	01/02/2013
5	234	CAS	16/02/2013
6	234	CAS	16/02/2013
Sheet1

 

[Antonio12]

Thank you very much for your help. It worked!