Thread
:
What is the right function
View Single Post
#
2
Posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
Posts: 35,218
What is the right function
=index(a:a,match(min(b:b),b:b,0))
is one way to get the first part number with the smallest price.
wrote:
Hello I have a problem I have to get the name of a Part that have the
lowest price in a COL
I have to colums one with name of parts and the other with prices
and i want to get the name of the lowest price part
what function do i have to use??
10x in advance
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson