Highlight duplicates, create a unique list, generate a summary report
Highlight duplicates, Create a unique list, generate a summary report, compare lists and best of all, Prevent further duplicates. Change your formulae references from Absolute to Relative and vice versa. Works on Selection, Active sheet or the entire Workbook. Sheet Index add-in will create an Index sheet of all sheets in your Workbook. Additional option allows you to create a Link back to Index link on all sheets. This is 8 add-ins in one. It can sort sheets and create pre-named sheets. Easily create 8 different types of dynamic named ranges. Generate a report of all formulae. Create live calenders, generate random numbers, run macros on pre-set times and much more. PAID version comes with a FREE Excel Workbook file size reducer. you can free download Add in OzGrid Collection N/A now.