Ask about function in excel to find the 2 closest numbers in 2 different columns condition have a common value in a third column
for example:
there's 3 columns of data code , price , taxes and given target price and target taxes i want to find the closest for each one but have condition they both have the same code
for example:
there's 3 columns of data code , price , taxes and given target price and target taxes i want to find the closest for each one but have condition they both have the same code