Hi Guys,
I have a table like the one copied below and for each value in column A I need the formula checks on column B giving back the latest date.
- Values in A are unquantified and they consist in alphanumeric codes.
- For each values there can be an unquantified number of dates.
- List is extremely long (thousands of rows)
I tried something like :
=MAX((@$A$2:$A$31=D2)*@$B$2:$B$31)
where in D there is a the same list I have in A , however it didn't work, not sure why as it used to in the past...
any help is really appreciated.
I have a table like the one copied below and for each value in column A I need the formula checks on column B giving back the latest date.
- Values in A are unquantified and they consist in alphanumeric codes.
- For each values there can be an unquantified number of dates.
- List is extremely long (thousands of rows)
I tried something like :
=MAX((@$A$2:$A$31=D2)*@$B$2:$B$31)
where in D there is a the same list I have in A , however it didn't work, not sure why as it used to in the past...
any help is really appreciated.
| Check_Price.xls | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | Products | Lastest PO's | Latest date | Products | ||
| 2 | a | 11/14/2016 | a | |||
| 3 | b | 11/14/2016 | b | |||
| 4 | b | 11/14/2016 | b | |||
| 5 | a | 11/2/2016 | a | |||
| 6 | c | 7/21/2016 | c | |||
| 7 | c | 11/14/2016 | c | |||
| 8 | c | 11/8/2016 | c | |||
| 9 | a | 11/8/2016 | a | |||
| 10 | f | 5/11/2016 | f | |||
| 11 | f | 7/1/2016 | f | |||
| 12 | c | 11/14/2016 | c | |||
| 13 | f | 10/21/2016 | f | |||
| 14 | z | 5/11/2016 | z | |||
| 15 | z | 10/18/2016 | z | |||
| 16 | a | 7/1/2016 | a | |||
| 17 | a | 8/18/2016 | a | |||
| 18 | a | 8/18/2016 | a | |||
| 19 | f | 10/14/2016 | f | |||
| 20 | h | 10/14/2016 | h | |||
| 21 | h | 9/28/2016 | h | |||
| 22 | c | 11/14/2016 | c | |||
| 23 | c | 11/14/2016 | c | |||
| 24 | c | 11/14/2016 | c | |||
| 25 | b | 11/14/2016 | b | |||
| 26 | q | 11/14/2016 | q | |||
| 27 | q | 11/14/2016 | q | |||
| 28 | q | 11/14/2016 | q | |||
| 29 | l | 11/14/2016 | l | |||
| 30 | l | 11/14/2016 | l | |||
| 31 | l | 6/20/2016 | l | |||
Sheet3 | ||||||
