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 h...
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