RGB Values to Color Names in Data Table

[#1]

I have a data table that contains RGB values in separate columns and I want to have the name of the color ( or close to it) displayed in a seperate column.

One problem is that I can give some leeway in the values so they could be in a range of values so Black could be 0-0-0 or 5-0-0 or 0-5-0 or 0-0-5 or 5-5-0 to 5-5-5 etc. so a range of +/- 5 either side would be allowable

e.g.

Color Name	RGB CODE	R	G	B
Black	0-0-0	0	0	0
Blue	0-0-255	0	0	255
Light Blue	173-216-230	173	216	230
Yellow	255-255-0	255	255	0
Orange	255-165-0	255	165	0
Deep Pink	255-20-147	255	20	147
Pink	255-192-203	255	192	203
Brown	165-42-42	165	42	42

[#2]

MS's column formula is great!

That last line is not just elegant but probably performs faster than my loops.

I updated the script RGB Color Matching Script.

Thanks MS!