Hello All,
I just took my first VBA course and brand new to the forum. I was hoping for some help in deleting duplicate values based off of multiple criterea. Each item has a unique Sec Code. I do not care about the "Group column." My desired results will show the security codes with all of the unique rates. Item 1 has 3 different rates (text color red in the desired results). So ideally, I would like to delete duplicates on items that have the same sec code and rate.
Any help would be greatly appreciated.
- JaysVBA
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL span=2><COL></COLGROUP>
I just took my first VBA course and brand new to the forum. I was hoping for some help in deleting duplicate values based off of multiple criterea. Each item has a unique Sec Code. I do not care about the "Group column." My desired results will show the security codes with all of the unique rates. Item 1 has 3 different rates (text color red in the desired results). So ideally, I would like to delete duplicates on items that have the same sec code and rate.
Any help would be greatly appreciated.
- JaysVBA
Raw Data</SPAN> | |||||
Group</SPAN> | Sec Code</SPAN> | Item Name</SPAN> | Purchase</SPAN> | Pay Date</SPAN> | Rate</SPAN> |
12345</SPAN> | 11396Q102</SPAN> | Item 1</SPAN> | 08-Jan-14</SPAN> | 03-Feb-14</SPAN> | 0.45</SPAN> |
12345</SPAN> | 123456789</SPAN> | Item 2</SPAN> | 13-Jan-14</SPAN> | 17-Feb-14</SPAN> | 0.23</SPAN> |
ABCD</SPAN> | 11396Q102</SPAN> | Item 1</SPAN> | 08-Jan-14</SPAN> | 03-Feb-14</SPAN> | 0.45</SPAN> |
ABCD</SPAN> | 035710411</SPAN> | Item 3</SPAN> | 27-Dec-13</SPAN> | 31-Jan-14</SPAN> | 0.3</SPAN> |
ABCD</SPAN> | 11396Q102</SPAN> | Item 1</SPAN> | 27-Dec-13</SPAN> | 31-Jan-14</SPAN> | 0.4</SPAN> |
6789</SPAN> | 11396Q102</SPAN> | Item 1</SPAN> | 08-Jan-14</SPAN> | 03-Feb-14</SPAN> | 0.48</SPAN> |
6789</SPAN> | 123456789</SPAN> | Item 2</SPAN> | 13-Jan-14</SPAN> | 17-Feb-14</SPAN> | 0.23</SPAN> |
6789</SPAN> | 00287Y109</SPAN> | Item 4</SPAN> | 13-Jan-14</SPAN> | 14-Feb-14</SPAN> | 0.4</SPAN> |
Desired Results</SPAN> | |||||
Group</SPAN> | Sec Code</SPAN> | Item Name</SPAN> | Purchase</SPAN> | Pay Date</SPAN> | Rate</SPAN> |
12345</SPAN> | 11396Q102</SPAN> | Item 1</SPAN> | 08-Jan-14</SPAN> | 03-Feb-14</SPAN> | 0.45</SPAN> |
12345</SPAN> | 123456789</SPAN> | Item 2</SPAN> | 13-Jan-14</SPAN> | 17-Feb-14</SPAN> | 0.23</SPAN> |
ABCD</SPAN> | 035710411</SPAN> | Item 3</SPAN> | 27-Dec-13</SPAN> | 31-Jan-14</SPAN> | 0.3</SPAN> |
ABCD</SPAN> | 11396Q102</SPAN> | Item 1</SPAN> | 27-Dec-13</SPAN> | 31-Jan-14</SPAN> | 0.4</SPAN> |
6789</SPAN> | 11396Q102</SPAN> | Item 1</SPAN> | 08-Jan-14</SPAN> | 03-Feb-14</SPAN> | 0.48</SPAN> |
6789</SPAN> | 00287Y109</SPAN> | Item 4</SPAN> | 13-Jan-14</SPAN> | 14-Feb-14</SPAN> | 0.4</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL span=2><COL></COLGROUP>