Thread: (Advanced) Filter Item ID with Lowest Price

Hi,

I suspect this might be simple enough but I can't find the solution...

I would greatly appreciate if somebody could suggest the advanced filter criteria range setup and syntax that would allow me to filter records in a table according to the attached example.

Basically, in a list containing duplicate item IDs (with corresponding pricing) I just want to display a unique record for each Item ID displaying the lowest price available.

Many thanks
Orson.

With a pivot table, it is easily done. You ask to show the minimum value of Cost for each row item in the value table. See attached file.