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.
<tbody>
</tbody>
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
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.
Card Nuumber | Location | Date |
123 | LOC | 18/01/2013 |
321 | MAD | 17/01/2013 |
234 | CAS | 01/02/2013 |
234 | CAS | 16/02/2013 |
234 | CAS | 16/02/2013 |
<tbody>
</tbody>
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