CODEWITHSUNDEEP
exceldate
jonathan9879
jonathan9879

Reputation: 155

Latest date of specific columns in excel

I have been a few days thinking about a problem in excel and I just can't seem to find a solution so I am trying this page for the first time.

The problem is as follows:

I have a set of columns that specify the name, type and model of different products. In addition I have a column with the date it was released and a column that says if the row is the latest in its specific name, type and model or not (they have to be the same to compare the dates). I wanted to automate this column as I have done with others but I don't even know where to start. It seems incredibly difficult compared to the others I have done.

Sample:

If someone could help me with this I would really appreciate. Any clue or idea is helpful.

Upvotes: 0

Views: 68

Answers (1)

Tom Sharpe
Tom Sharpe

Reputation: 34265

OK the formula you need in E2 would look like this:-

=IF(COUNTIFS(A$2:A$4,A2,B$2:B$4,B2,C$2:C$4,C2,D$2:D$4,">"&D2),"No","Yes")

if the data are in columns A to D with headers in row 1. Then pull it down to E3, E4 etc.

This says:-

'If there are any matching products with a later date, then this can't be the latest one, so put "No" '.

'If there are no matching products with a later date, then this must be the latest, so put "Yes"' (or at least joint latest, if there are two or more with the same date).

enter image description here

Upvotes: 1

Related Questions