close

Hi all,

I have an excel file with the following format:

Account Date Amount
00110 1/20/2005 120.51
00110 6/2/2005 87.01
00110 8/15/2005 255.09
02055 2/5/2005 70.05
02055 4/1/2005 192.88
15240 2/20/2005 457.18
15240 9/21/2005 19.77
.... and so on.
The file has 12000 entries for over 500 different accounts.

I would like to select the entries for each account with the latest
date.

How do I do this?

Thanks,

GordonGot it.

Use Subtotal function.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄