Spreadsheet: 758094d1638640850-how-to-extract-records-having-the-same-entry-and-exit-date-test-041221-find-records-based-on-sameday-entry-exit
Sheet: extract same date_041221

 | Symbol | ISIN | Entry Date | Exit Date | Quantity | Buy Value | Sell Value | Profit | Period of Holding | Turnover
 |  |  | Entry Date=Exit Date
 | Symbol | ISIN | Entry Date | Exit Date | Quantity | Buy Value | Sell Value | Profit | Period of Holding | Turnover
 | CERA | INE739E01017 | 2020-04-09 | 2020-04-16 | 4 | 8740 | 8964 | 224 | 7 | 0
 | FEDERALBNK | INE171A01029 | 2020-04-13 | 2020-04-24 | 30 | 1209 | 1315.5 | 106.5 | 11 | 0
 | [NAME] | INE885A01032 | 2020-04-13 | 2020-06-11 | 5 | 2500 | 3245 | 745 | 59 | 0
 | ZEEL | INE256A01028 | 2020-04-13 | 2021-01-12 | 20 | 2598 | 4496 | 1898 | 274 | 0
 | SRTRANSFIN | INE721A01013 | 2020-04-15 | 2021-01-12 | 5 | 3490 | 6366.5 | 2876.5 | 272 | 0
 | LICHSGFIN | INE115A01026 | 2020-04-15 | 2021-01-12 | 10 | 2560 | 4373.5 | 1813.5 | 272 | 0
 | KOTAKBANK | INE237A01028 | 2020-04-17 | 2020-04-24 | 10 | 11496 | 12398.5 | 902.5 | 7 | 0
 | FEDERALBNK | INE171A01029 | 2020-04-20 | 2020-04-20 | 2 | 92.3 | 93.1 | 0.8 | 0 | 0.8
 | FEDERALBNK | INE171A01029 | 2020-04-20 | 2020-04-20 | 6 | 276.9 | 279.3 | 2.4 | 0 | 2.4
 | FEDERALBNK | INE171A01029 | 2020-04-20 | 2020-04-20 | 1 | 46.15 | 46.55 | 0.4 | 0 | 0.4
 | FEDERALBNK | INE171A01029 | 2020-04-20 | 2020-04-20 | 12 | 553.8 | 558.6 | 4.8 | 0 | 4.8
 | FEDERALBNK | INE171A01029 | 2020-04-20 | 2020-04-20 | 6 | 276.9 | 279.3 | 2.4 | 0 | 2.4
 | FEDERALBNK | INE171A01029 | 2020-04-20 | 2020-04-20 | 1 | 46.15 | 46.55 | 0.4 | 0 | 0.4
 | FEDERALBNK | INE171A01029 | 2020-04-20 | 2020-04-20 | 2 | 92.3 | 93.1 | 0.8 | 0 | 0.8
 | FEDERALBNK | INE171A01029 | 2020-04-20 | 2020-04-20 | 10 | 461.5 | 464.5 | 3 | 0 | 3
 | FEDERALBNK | INE171A01029 | 2020-04-20 | 2020-04-20 | 6 | 276.9 | 278.7 | 1.8 | 0 | 1.8
 | FEDERALBNK | INE171A01029 | 2020-04-20 | 2020-04-20 | 1 | 46.15 | 46.45 | 0.3 | 0 | 0.3
 | FEDERALBNK | INE171A01029 | 2020-04-20 | 2020-04-20 | 12 | 553.8 | 557.4 | 3.6 | 0 | 3.6
 | FEDERALBNK | INE171A01029 | 2020-04-20 | 2020-04-20 | 1 | 46.15 | 46.45 | 0.3 | 0 | 0.3
 | KOTAKBANK | INE237A01028 | 2020-04-20 | 2020-04-24 | 20 | 24315 | 24797 | 482 | 4 | 0
 | VEDL | INE205A01025 | 2020-04-20 | 2021-01-12 | 14 | 1194.9 | 2542.4 | 1347.5 | 267 | 0
 | ZEEL | INE256A01028 | 2020-04-21 | 2021-01-12 | 5 | 645 | 1124 | 479 | 266 | 0
 | JAGRAN | INE199G01027 | 2020-04-21 | 2021-02-17 | 38 | 1708.1 | 1801.2 | 93.1 | 302 | 0
 | JAGRAN | INE199G01027 | 2020-04-21 | 2021-02-17 | 6 | 269.7 | 284.4 | 14.7 | 302 | 0
 | JAGRAN | INE199G01027 | 2020-04-21 | 2021-02-17 | 56 | 2517.2 | 2654.4 | 137.2 | 302 | 0
 | BATAINDIA | INE176A01028 | 2020-04-22 | 2020-04-22 | 20 | 24240 | 24299 | 59 | 0 | 59
 | PHILIPCARB | INE602A01023 | 2020-04-22 | 2020-08-13 | 77 | 6221.6 | 9405.55 | 3183.95 | 113 | 0
 | PHILIPCARB | INE602A01023 | 2020-04-22 | 2020-08-13 | 15 | 1212 | 1832.25 | 620.25 | 113 | 0
 | PHILIPCARB | INE602A01023 | 2020-04-22 | 2020-08-13 | 8 | 646.4 | 977.2 | 330.8 | 113 | 0
 | JAGRAN | INE199G01027 | 2020-04-22 | 2021-02-17 | 50 | 2250 | 2370 | 120 | 301 | 0
 | BAJFINANCE | INE296A01024 | 2020-04-23 | 2020-04-23 | 10 | 21921 | 21980 | 59 | 0 | 59
 | how to extract records having the same entry and exit date?  Col  D:E
 | advanced filter- criteria= col D equals col E