title: to get last row of each day from excel sheet
body: <p>i need to find the last record of each day in excel if there are multiple entries </p>
  
  <blockquote>
    <p>*******intention is to get EOD balance ROW OF EACH DATE********</p>
  </blockquote>
  
  <p>like i have data in excel something like this </p>
  
  <pre><code>date             CR_DR amount EOD balance
  ----------------------
  7/9/2017 19:09  CR       10       10
  7/10/2017 18:37 CR       25       35
  7/10/2017 21:06 DR       10       25
  7/11/2017 19:21 CR       15       40  
  7/15/2017 14:17 DR       20       20
  7/17/2017 17:12 CR       100     120
  7/18/2017 7:44  DR       30       90
  7/18/2017 14:08 DR       50       40
  7/18/2017 16:52 CR       120     160
  </code></pre>
  
  <p>for which i need to get data like (get the last row of each day)</p>
  
  <pre><code>7/9/2017 19:09  CR       10       10
  7/10/2017 21:06 DR       10       25
  7/11/2017 19:21 CR       15       40  
  7/15/2017 14:17 DR       20       20
  7/17/2017 17:12 CR       100     120
  7/18/2017 16:52 CR       120     160
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/Tucdr.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Tucdr.jpg" alt="adding output of formula applied "></a></p>
  
  <p><a href="https://i.stack.imgur.com/7SaS7.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7SaS7.jpg" alt="data post updated comments"></a></p>