To find out which Vendor has the lowest Price for each PN

[nironto]

Hi All,
I have a list of 50000 pricing records and I need to tabulate a list for :-
Each PN which vendor has the lowest price.
Tried pivot tables, but does not work out.

Is there any simple formula \ macros that I can get these information generated without having to go through them manually \ getting too complex?
Appreciate your help!

Regards,
Nironto

[Vikas_Gautam]

got the solution..

I have used array formula so use ctrl + shift + enter... to enter the formula..

check the attached file..



Don't forget to click *

[ajryan88]

Hi,

I've written a solution on the worksheet that I have called "AJRYAN88".

It uses quite a complex array formula, but I think it achieves what you're asking for nonetheless.

I hope this helps

[nironto]

Hi Vikas_Gautam and ajryan88,
Thanks! Great piece of work. Both Solution works!

Regards,
Nironto