Forum Discussion
Help with data - comparing 3 values against 3 other values to find the closest match
I want to compare 3 values in table A (actually Height, Width, Depth) against 3 values in table B to find out which row is the cloest match of all three values (and ideally how close)
So Item 1 has values of say 100,200,300
and I want to compare against a list
Row 1 - 100,250,300
Row 2 - 80,200,180
Row 3 - 120,220,220
etc
So i need to know both the closest match, and the difference
In the above example it would be row 1 , and the difference would be (0,50,0)
Can this be done in Excel?
3 Replies
IMHO, technically the task is not clearly defined
1) are dimensions the numbers in separate cells or the string in one cell with separated by commas numbers
2) What is the measure for minimum deviation (min sum of deviations for each dimension, or volume, or sum of dimensions, whatever)
3) What to do if you have several items with exactly same minimum deviation measure (but probaly different dimensions) - show them all or just first founded one
4) Where to show the record(s) with minimum deviation - just highlight main records and add on next column dimension difference; or that shall be in separate list
- You can use ROUND and SUBTRACT for solving this one. Hope you send sample, to make it clear.
Yes, We can.
But send screen shot of file (or) send that file.
