Using the MIN IF Function

[aware073]

Hi! I'm not an excel newbie but just learning all about the different functions that can make my job a lot easier.. In the spreadsheet I'm working on I know I need to use a MIN IF formula but I cant seem to get it to work. I have a list of Part Numbers in Column A, repeated multiple times according to how many different purchase prices there have been. Column D has those purchase prices listed. I need column E to be the lowest purchase price for each part number. Any suggestions?

My example:
A D E(Desired)
2000007 8.49 7.27
2000007 7.36 7.27
2000007 8.24 7.27
2000007 7.27 7.27
2000009 8.47 4.85
2000009 4.85 4.85
2000008 3.21 3.21

 

[gaz_chops]

Welcome to the forum.

Try this entered as an array.
=MIN(IF($A$1:$A$100=A1,$D$1:$D$100))

 

[aware073]

Thanks for the response. I tried that but I'm getting the lowest of rows 1-100 in every box

 

[gaz_chops]

Because you didn't enter as an array. You must enter using Ctrl, Shift & Enter, if done correctly you'll see curly brackets either side in the formula bar.

 

[aware073]

Because you didn't enter as an array. You must enter using Ctrl, Shift & Enter, if done correctly you'll see curly brackets either side in the formula bar.

Ah that worked perfect. Thank you so so much!

 

[gaz_chops]

You're welcome.