# With multiple entries for each day, how to report only the last value for a daily balance

#### Jflato

##### New Member
I feel like there is something basic I am missing here, but I can't figure this one out.

The most basic way for me to put the question I have would be this:

If I have data which is arranged by date (some dates have a single row of data, some have multiple), each row of which contains a running balance, how can I get only the last row of each date to display? For instance, in the below, I want to have only the last value for each day display, so I'd have one row for 2/4, one row for 2/5, one row for 2/6 and one row for 2/7. No sum of numbers from the Balance column is necessary. Any ideas?

 Date Balance 2/4/14 100 2/5/14 150 2/5/14 93 2/6/14 145 2/6/14 800 2/7/14 850

<tbody>
</tbody>

### Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

#### RonB1111

##### Well-known Member
Enter this formula in C2 and copy down:
=A2=A3
Turn on Data-Filter and filter column C for FALSE

#### Weazel

##### Well-known Member
maybe something like....

E2 =INDEX(\$B\$2:\$B\$7,MATCH(9.99E+307,IF(\$A\$2:\$A\$7=D2,\$B\$2:\$B\$7))) Control Shift Enter

 A B C D E 1 Date Balance Date Balance 2 2/4/2014 100 2/4/2014 100 3 2/5/2014 150 2/5/2014 93 4 2/5/2014 93 2/6/2014 800 5 2/6/2014 145 2/7/2014 850 6 2/6/2014 800 7 2/7/2014 850

<TBODY>
</TBODY>

#### Jflato

##### New Member
Thanks to both of you. The simple =A2=A3 worked perfectly!

#### RonB1111

##### Well-known Member
Thanks to both of you. The simple =A2=A3 worked perfectly!

You're welcome!

Replies
0
Views
1K
Replies
3
Views
509
Replies
6
Views
352
Replies
1
Views
343
Replies
0
Views
383

1,191,320
Messages
5,985,964
Members
439,992
Latest member
NCWalker

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back