Duplicates and top values
Exercise 1 of 3
Some members appear twice. In D2, write a rule that is TRUE when the name in row 2 appears more than once in A2:A9.
About this lesson
Rules can count or rank against the whole list: flag names that appear twice, the top three values, or anything above average. The list range needs $ so it doesn't move.
In this lesson
- Some members appear twice. In
D2, write a rule that is TRUE when the name in row 2 appears more than once in A2:A9. - Highlight the top three points. In
D2, write a rule that is TRUE when the points are at least the third-largest value. - Highlight the members above the average. Write the rule in
D2.
Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.
fx
Type in D2 and press Enter to check.