Hi there, I have a list with 2000 product, a lot of products on the list are 95% the same for example.


Sigma 18-250mm F3 5-6 3 DC OS HSM (Nikon)
Sigma 18-250mm F3.5-6.3 DC OS HSM (Canon)
Sigma 18-250mm F3.5-6.3 DC OS HSM (Sony)

The only difference is what's in the brackets (). To save time when listing products on my website I used: Sigma 18-250mm F3 5-6 3 DC OS HSM, and for the the type: (Nikon)(Canon)(Sony) I have a dropdown menu for people to choose from, but there is downside to this, when I downlaod .CSV file from the my wesbite and compare it to suppliers list it shows (Canon), (Sony) as new produts. So what I need is to compare my website listed products to my suppliers list and if it finds:

Sigma 18-250mm F3 5-6 3 DC OS HSM

on my list, to put a border around all 3 product on my suppliers list.

This part is optional, if its too much work, dont worry about, if not I would really appreciate your help.

On list in column A I have product description and in column B I have prices, sometimes Sigma 18-250mm F3 5-6 3 DC OS HSM (Nikon) lets say costs $450 but the (Canon cost) $460 and (Sony) $470, would it be possible to display them goruped together and show for Canon +10 and for Sony +20, which would indicate the price different.

If you have questions please let me know. Your help is much appreciated.

Sample of suppliers list:
Description: Price:
Sigma 17-50mm F/2.8 EX DC OS HSM (Canon)
Sigma 17-50mm F/2.8 EX DC OS HSM (Nikon)
Sigma 17-70mm F2.8-4 DC MACRO OS HSM (Canon)
Sigma 17-70mm F2.8-4 DC MACRO OS HSM (Nikon)
Sigma 17-70mm F2.8-4 DC MACRO OS HSM (Pentax)
Sigma 17-70mm F2.8-4 DC MACRO OS HSM (Sony)
Sigma 18-125mm F3.8-5.6 DC OS HSM (Canon)
Sigma 18-125mm F3.8-5.6 DC OS HSM (Nikon)
Sigma 18-200mm F3.5-6.3 DC (Canon)
Sigma 18-200mm F3.5-6.3 DC (Nikon)
Sigma 18-200mm F3.5-6.3 DC OS (Canon)
Sigma 18-200mm F3.5-6.3 DC OS HSM (Nikon)
Sigma 18-250mm F3 5-6 3 DC OS HSM (Nikon)
Sigma 18-250mm F3.5-6.3 DC OS HSM (Canon)
Sigma 18-250mm F3.5-6.3 DC OS HSM (Sony)
Sigma 18-50mm F/2.8 EX DC MACRO HSM (Nikon)
Sigma 18-50mm F2.8 EX DC MACRO (Canon)
Sigma 18-50mm F2.8 EX DC MACRO (Sony)
Sigma 18-50mm F2.8-4.5 DC OS HSM (Canon)
Sigma 18-50mm F2.8-4.5 DC OS HSM (Nikon)
Sigma 20mm F1.8 EX DG Aspherical RF (Canon)
Sigma 20mm F1.8 EX DG ASPHERICAL RF (Nikon)
Sigma 24-70mm F2.8 EX DG HSM (Canon)
Sigma 24-70mm F2.8 EX DG HSM (Nikon)



Thanks Gary