Filling in missing title information


show more Filling in missing title information provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Cleaning Up Your Excel 2010 Data show less
please wait ...

Filling in missing title information

Sometimes for printing reasons, or just for clear visual display, all but the first entry of a series of repeating entries have been deleted. For example, as we look in column A, we don't see the department name ADC repeated in rows 3 through 6. We don't see Admin Training repeated in row 8 downward. And setting up data like this does make the data easier to read. But if we want to sort this data by Status or Benefits or Salary or any other column, once we do that, we don't have any way to return to this layout.

In other words, we actually need to fill in Column A with the data that's missing. So what we like to do is to have ADC appear here, here, here, and here. Now, this might be a huge list. It happens to be about 700 names. It could be 7,000, hundreds of thousands possibly. What we need to do is use a technique not so widely used that essentially allows us, first of all, to select the blank cells here, and then what we are going to do is write a formula for each of th...

Filling in missing title information
Video duration: 3m 29s 1h 28m Appropriate for all

Viewers:

Filling in missing title information provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Cleaning Up Your Excel 2010 Data

Subjects:
Business IT
Software:
Excel
Author:
please wait ...