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

[Jflato]

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>

 

[RonB1111]

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

 

[Weazel]

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</SPAN>	Balance</SPAN>		Date</SPAN>	Balance</SPAN>
2	2/4/2014 </SPAN>	100</SPAN>		2/4/2014 </SPAN>	100</SPAN>
3	2/5/2014 </SPAN>	150</SPAN>		2/5/2014 </SPAN>	93</SPAN>
4	2/5/2014 </SPAN>	93</SPAN>		2/6/2014 </SPAN>	800</SPAN>
5	2/6/2014 </SPAN>	145</SPAN>		2/7/2014 </SPAN>	850</SPAN>
6	2/6/2014 </SPAN>	800</SPAN>
7	2/7/2014 </SPAN>	850</SPAN>

<TBODY>
</TBODY>

 

[Jflato]

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

 

[RonB1111]

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

You're welcome!