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
Bookmarks