Forum Discussion
UNIQUE function
Say you have 100 characters in column one. How would you use the unique function to grab only characters 7-10 in 5000 rows and paste it onto a new sheet?
Let's say the texts are in A1:A5000 on Sheet 1.
In a cell on another sheet
=UNIQUE(MID('Sheet 1'!A1:A5000, 7, 4))