Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

First you need a reference-range of 750 rows and 2 Columns:

→Data→Filter→Standardfilter →→[x]without Duplicates into [x]other …
in the Column right of filtered Output fill with Formula =ROW()

use right to your original Data :

=VLOOKUP( A1 ;reference_Range;2;0)

and filldown