Spreadsheet Compare application Excel User tips

Extract current (Active) workbook name CELL

Links between two workbooks – dynamically using functions INDIRECT

Cuts string of list of items Formulas - combined functions

VALUE() of LEFT() Formulas - combined functions

When Excel functions are not enough Excel User tips

Extract Address into table Formulas - combined functions

Multiple-Validations (connected to each other) Data Validation