Formula help

[djs6025]

Hi Everybody,
I'm looking for a formula to look at duplicates in column A and return the lowest # in column D from those duplicates. I also need it to ignore the cells with "#N/A". The answer & formula will be in column E. Hopefully, I've explain that well enough. Below is a link to a screen shot I took for what I'm looking for. Thanks so much for your help.

https://imgur.com/a/Rp2Bc

Thanks,
Dan

 

[jorismoerings]

Hi,

take a look at this:

Book1
	A	B	C	D	E
1	LQP-H260	272,8	13	42,23	42,23
2	LQP-H260	272,8	13	44,34	42,23
3	LQP-H260	272,8	13	#N/A	42,23
4	LTP-L330	420,36	3	56,22	53,29
5	LTP-L330	420,36	3	53,29	53,29
6	LTP-L330	420,36	3	54,78	53,29
7	LTP-L330	420,36	3	#N/A	53,29
8	LLP-P210	132,68	2	20,26	20,26
9	LLP-P210	132,68	2	23,38	20,26
10	LLP-P210	132,68	2	23,34	20,26
Sheet1

Cell Formulas
Range	Formula
E1	{=MIN(IF(($A$1:$A$10=A1)*NOT(ISNA($D$1:$D$10)),$D$1:$D$10))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[djs6025]

Thanks for the reply. Unfortunately, I couldn't get this to work. All the answers were either "0" or "#N/A".