Page 142 - Lean six sigma demystified

Chapter 4 e xC e L Power Too LS for Lean Six Sigm a 121

FIGURE 4-18 • Creating a validation list.

FIGURE 4-19 • Selecting list for validation.

Then select columns B:G and Data Validation-List to specify the source list
(=$I$2:$I$50). See Fig. 4-19.
This will add a dropdown list to every cell so that employees can type a valid
time (e.g., 2.5) or select a valid time (Fig. 4-20). Then just hide column I and
save the workbook.

FIGURE 4-20 • Valida-
tion using menu of list
items.