How to quickly jump to next unique value in an Excel column?

If there is a list of data which includes duplicate and unique values, and you want to jump to the next unique value and ignore the duplicates as below screenshot shown. Here I introduce some tricks to help you directly go to the next unique value in an Excel column.

Jump to next unique value by shortcuts

Jump to next unique value by Go To Special function

---

Jump to next unique value by shortcuts

---

Select the whole column which you want to jump to the unique values, and hold Shift + Ctrl keys, then press | key to jump to the next unique value.

---

Jump to next unique value by Go To Special function

With the Go To Special function, you also can jump to next unique value.

1. Select the whole column that you use, and press F5 key to enable the Go To dialog, click Special to go to the Go To Special dialog. See screenshot:

2. In the Go To Special dialog, check Column differences option, and click OK, and the first unique value has been found out in the column.

Note: If there is no header in the column, the first value will be ignored.

3. Repeat above steps to jump to next unique value one by one.

You maybe insterested in this:

---

Select Duplicate & Unique Cells (quickly select duplicate or unique values in a column.

Go to Download Free Trial 60 days

---

---

Excel Productivity Tools