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

 

[ThomasD]

The Dates were Text; changed them to date format and still zeroes.

 

[Fluff]

In that case can you post some sample data.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[ThomasD]

Fluff,

I appreciate all your time and effort today. I have to hop back to 2024 budgets and year-end cost updates. If time permits, I will try the upload tool tomorrow or when time permits.

Thanks for all your help.

Tom

 

[Fluff]

Ok

 

[ThomasD]

Fluff,

Thank you for all your time and effort. It turns out your =maxifs() formula worked. The date format was still messed up. When I fixed that, the formula worked.

Thanks again,

Tom

 

[Fluff]

Glad it's sorted & thanks for letting us know.