index match in range based on id number

I have a table of about 12,000 records. Each customer has a unique id, but may appear more than once (with the same id) on different dates.

I'm trying to do something like this: index([date],match(1,[used coupon],0). This seems to work fine, but I need to specific the range of the [used coupon] column to look in to only rows with the customer ID.

Sample workbook attached.indexmatch sample.xlsx

I am not quite sure what you want, but if you want to get the latest date associated with a person, the following formula entered as an array formula should do it.
=MAX(IF(A3=$A$3:$A$14,$D$3:$D$14,FALSE))
To get an understanding on how array formulas work, see this article. http://www.utteraccess.com/wiki/inde...Array_Formulas
See column C in the example.

I also recommend that you convert your data to an Excel table so you can reference only the amount of data you want without having to reference the whole million rows in the column.

Hi

Try these array formula (CTRL+SHIFT+ENTER)

Formula:

Please Login or Register  to view this content.

Regards

Or use

Formula:

Please Login or Register  to view this content.