如何从一列中获取最大日期并与Excel中的另一列匹配? [英] How to get max date from one column and match with other column in Excel?

问题描述

我有如下的excel工作表数据

I have excel sheet data like below

CustomerNo LoginDate
101        25/05/2012
101        10/05/2012
101        20/05/2012
101        10/04/2012
102        21/05/2012
102        12/04/2012
103        20/05/2012
104        08/04/2012

我想获取上次登录日期与客户编号匹配的结果，如下所示.

I want to get last login date match with customer number and result like below.

101   25/05/2012
102   21/05/2012
103   20/05/2012
104   08/04/2012

推荐答案

有两种方法:

1. 具有数组功能(按Ctrl + Shift + Enter):

=MAX(IF($A$2:$A$9=C2,$B$2:$B$9))

1. 常规公式:

=MAX(INDEX(($A$2:$A$9=C2)*($B$2:$B$9),,1))

我个人更喜欢第二种方法，因为阵列功能会降低大数据的PC性能.无论如何，希望这会有所帮助.

I personally like the 2nd way better since array function will slow down PC performance for huge data. Anyway, hope this helps.

这篇关于如何从一列中获取最大日期并与Excel中的另一列匹配?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！