On Wednesday, December 18, 2013 12:07:12 AM UTC-8, Claus Busch wrote:
Hi Howard,



Am Tue, 17 Dec 2013 17:53:30 -0800 (PST) schrieb Howard:



https://www.dropbox.com/s/dgy83hwqa4...rop%20Box.xlsm



if you had real numbers you could look for the next larger or next

smaller number. But with your strings it is not so easy.

Please have a look:

https://skydrive.live.com/#cid=9378A...121822A3%21326

for the workbook "Assemble Number" and test it





Regards

Claus B.


Well, that itself is pretty clever, I used easy to produce test data not thinking it would make any difference what was in the cell.

This would be more of a representation of what you would see in the drop downs in a working workbook. The Data Validation may be the most practical.

UK Plug

IEC 60320 C13

5 Meter

H05VV F 3G1.0mm2

Black

H05VV-F 3G1.0mm2 3A/250V

I'll look into the DV method.

Thanks, Claus.