Looking for closest value without duplicates

[gehawk]

Hi guys,

I am looking for a way to match the closest value in a column without any duplicates.
I used the following method :

https://www.extendoffice.com/docume...est-nearest-value-greater-than-less-than.html

This method worked fine : however I am looking for one extra thing : the matches need to be unique (i.e 1 value can only be used once to match).

I am not sure what would be the best way maybe : once the first match is done the formula calculates the best match for the remaining ones.

Hope someone can help me

Thanks
Gehawk

 

[Aladin Akyurek]

Care to post a sample (not a picture or an image) along with the desired results?

 

[gehawk]

File here : https://we.tl/t-7hjPSW4nr7

Added some comments as well.

Thanks

 

[Aladin Akyurek]

Gehawk,

What is required is the set of desired results, not the results of an (almost or non-working) formula. Is it possible that you post in column C those values manually and remove the formulas?

 

[gehawk]

Hi the expected results are in column G, it's the closest match to the value in column A but it has to be unique.

 

[Aladin Akyurek]

Hi the expected results are in column G, it's the closest match to the value in column A but it has to be unique.

Not sure as these are formula calculations.

1. What does ABS(F2-F2) in =IF(ABS(E2-A2) < ABS(F2-F2),E2,F2)<abs(f2-f2),e2,f2) g2?
mean?
2. What does "With number 1 belongs 13" mean?</abs(f2-f2),e2,f2)>