Finding the lowest cost dynamically

[traveler84]

On my spreadsheet, I have multiple addresses with vendor bids. The addresses might be slightly different such as an extra space or thoroughfare spelled (i.e. ST vs Street). So I was going to create a helper column that I will statically number for duplicated addresses. My list could be 10 addresses or could be 1000s. I'm trying to find a formula that can calculate the lowest cost in each group number for every address.

Here is a simplied version of the data: (could be 1 entry for an address or could be 10)

The output that I would like on another sheet would look like:

Where I am confused is how to keep running the formula to generate all the best options starting with 1 through the last number. In my mind, I am thinking of some kind of loop function that seeks all the remaining options until the last number. If the data was static, I am pretty confident I could figure it out but since the address lists could vary day to day, that's my challenge.

The SMALL function might work if I could figure out the loop till the last number and output each number. I am open to VBA which isn't my strong suit if that's what I need.

Thank you all so very much.

 

[Peter_SSs]

Using Fluff's formula as a starting point, I think this one should also work for you.

traveler84.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	1	123 Elm	State	a	l	w	500		1	123 Elm	State	a	l	w	500
2	1	123 Elm street	State	b	m	x	600		1	123 Elm st	State	c	n	y	500
3	1	123 Elm st	State	c	n	y	500		2	100 Elm Street	State	e	p	aa	200
4									3	999 Elm	State	j	u	af	300
5	2	100 Elm Street	State	e	p	aa	200
6	2	100 Elm St.	State	f	q	ab	600
7
8	3	999 Elm	State	h	s	ad	500
9	3	999 Elm st	State	i	t	ae	600
10	3	999 Elm	State	j	u	af	300
Lowest (2)

Cell Formulas
Range	Formula
I1:O4	I1	=LET(a,A1:A1000,g,G1:G1000,u,UNIQUE(FILTER(a,a<>"")),FILTER(A1:G1000,IFNA(MATCH(a&"|"&g,u&"|"&MINIFS(g,a,u),0),0)))
Dynamic array formulas.