From the course: Excel 2016: Advanced Formatting Techniques

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Restore missing title data in a column

Restore missing title data in a column

From the course: Excel 2016: Advanced Formatting Techniques

Start my 1-month free trial

Restore missing title data in a column

“

- On this worksheet called MissingTitles, we can see in column A that we're only seeing departments when there's a new department being introduced. So by inference, based on the data here, these people are in the ADC department. These people are in Admin Training. And the data that should be here at some point along the line was taken out perhaps for printing reasons. Now the problem is what if we were to sort this data by employee name or any other column? We will lose the association. For example, Randy Nixon is in the ADC department but if we sort this row, in other words if this row moves up or down, there's no indication as to which department that person is in. So we've got a potential problem here if we sort the data. And I'll show you what happens right now. I'll click in column B. Let's do an A-Z sort. Now of course we have that Undo feature that's the lifesaver. A quick A-Z sort of this data based on what's in column B. There we are. What department is James Abbott in? We…

Contents