Great work TS for compiling this..

Can I suggest an improvement on the Google Sheet? Maybe can add a column for Max Discount % for vouchers with value & minimum purchase. This will allow a better comparison between the different vouchers?

E.g. TNG2015EVO is RM 30 off with minimum purchase of RM 100, so Max Discount % is 30%, while OCTAB1 is RM 20 off min purchase of RM 120, making it a Max Discount % of 16.7%.

Added my mods in column M.. If ugaiz ok, then can use to replace the current %..

It caters for both % and round values.. and uses a color scale to represent best vouchers by max discount %

Managed to get it to auto-populate using an ARRAYFORMULA, but cannot get the format to stick..