Look at formulae in sheet Peritem cells A2:C2.
If you find have repeating items in those lists you can wrap the formula with UNIQUE
Look at the Names aaa, bbb & ccc and note the # character at the end.
Look at the formula in cell F2 of sheet List.
Look at the data validation in cells A2:A4 of the Data sheet, and note the # character.
The data validation in cells B2:B4 of the same sheet haven't changed.
|