Thread
:
Last Date in List
View Single Post
#
3
Ron Rosenfeld
Posts: n/a
On 3 Mar 2005 06:10:04 -0800,
(Edgar Thoemmes)
wrote:
Hi
I have a table set out as follows,
Account Date Text Amount
31405535 01/01/04 nnnn 100000
31405535 12/12/03 tttt 222222
31405535 03/03/05 ttt 122456
There are 5 different accounts which could be entered under Account.
The list is a export from out bank statement, I would like a formula
to display the last date of transaction per account number. For eg in
the above list I would like the formula to return 03/03/05.
Can anyone help?
TIA
The Array formula:
=MAX((Account=31405535)*Date)
To enter an array formula, after typing or pasting in the formula, hold down
<ctrl<shift while hitting <enter. Excel will place braces {...} around the
formula.
--ron
Reply With Quote