Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

(What a strange idea to attach an image in such a case instead of the spreadsheet file.)

Helper columns are a good idea generally. In this case also a solution without a helper column might be advisable if no additional access to the differebces is needed elsewhere. See this attached example for a demonstration. (An image wouldn't be of any use.)

(What a strange idea to attach an image in such a case instead of the spreadsheet file.)

Helper columns are a good idea generally. In this case also a solution without a helper column might be advisable if no additional access to the differebces is needed elsewhere. See this attached example for a demonstration. (An image wouldn't be of any use.)

A hint in addition: You need to decide how to handle cases where more than one entry would be equally good matches, but only the first one is found. You also need to decide if the first match concerning the absolute difference shall be accepted or if you prefer another match with the opposite difference (+1 e.g. instead of -1).

(What a strange idea to attach an image in such a case instead of the spreadsheet file.)file. It's hard to make use of and it's also the greater file size. Your image was 121 KB, my file is 15KB.)

Helper columns are a good idea generally. In this case also a solution without a helper column might be advisable if no additional access to the differebces is needed elsewhere. See this attached example for a demonstration. (An image wouldn't be of any use.)

A hint in addition: You need to decide how to handle cases where more than one entry would be equally good matches, but only the first one is found. You also need to decide if the first match concerning the absolute difference shall be accepted or if you prefer another match with the opposite difference (+1 e.g. instead of -1).