Finding the max lengh of values in a column is helpful when creating databases. This preview from our Excel Tips & Tricks course will help you do just that. Question What is the largest “Product Name” length? (a: 127) Steps: 1. Create a new row in “Orders” sheet above all the

Cleansing your data of duplicate values is essential to performing good analysis and finding answers. Here is a quick method we like to use that involves writing a formula. In our Excel Tips 2021 Course you will find tips like this along with many others. First, a simple example 1.