Multi-Formula Question - Prices/Date

[ThomasD]

I am trying to get the last receipt price and date for each unique2nd Item Number.

The formula in row 1 is what I have tried for latest Purchase Price (copied, not my creation).

I appreciate any and all help.

Thanks.

Tom

 

[Fluff]

Are the dates in col B always sorted oldest to newest?

 

[ThomasD]

Are the dates in col B always sorted oldest to newest?

No, they are not.

 

[Fluff]

Ok, how about

=CHOOSECOLS(TAKE(SORT(FILTER($B$3:$C$7000,$A$3:$A$7000=K3),1,-1),1),2,1)

 

[ThomasD]

Typed in the formula above but Excel does not like the "sort" in the formula

 

[Fluff]

Are you trying this in 365 as per your profile?

 

[ThomasD]

I apologize. The Excel version is 2019.

 

[Fluff]

Ok how about

=MAXIFS(B:B,A:A,K3)

and

=MAXIFS(C:C,A:A,K3,B:B,L3)

 

[ThomasD]

Ok how about

=MAXIFS(B:B,A:A,K3)

and

=MAXIFS(C:C,A:A,K3,B:B,L3)

Still returning zeroes.

 

[Fluff]

In that case check that your dates are real dates & not text.