Need MIN values to second set of values, UNIQUE only

[randyharris]

Can't figure this one out, I have two separate sets of data, they have month end dates in common. Data Set 1 has dollar values, there are repeated values in the columns of data, not all are unique. Data set 2 has percentages. I am trying to find the minimum percent for each unique dollar value in data Set 1.
ColumnB is related to F, ColumnC to G, and ColumnD to H.

In the example below, the unique value of $500 in Column B would result in -4%, $519 in Column C would result in -2% (nothing for $521 or $523 since they have no negative percentages associated with them - ditto or Column D values.)

Month	ColumnB	ColumnC	ColumnD	Month	ColumnF	ColumnG	ColumnH
JAN99	$500	$519	$502	JAN99		-2%
FEB99	$500	$521	$545	FEB99	-3%
MAR99	$500	$523	$555	MAR991	-4%

 

[Eric W]

Where/how do you want the results displayed? And what version of Excel do you have? Newer versions have newer functions which could help, but we don't want to suggest those if you don't have them.

 

[randyharris]

Thanks Eric, I'm on Excel for Mac 16.47, latest version for Mac.

I'll put columns over to the right, ideally a column of unique values and then next to it a column of the min percent related to it.