I have a spreadsheet that will be having data imported into it each week. The amount of data will change week to week. I then run a formula down these to pull out the first 3 chars of each cell.
I am now wanting to create some validation based on the first 3 letters, so I have created a named range that covers off the formula for the first 3 chars. However, to get the formula to work covering all data, I have copied it down a fair way so when I base the validation on this it has hundreds of blanks. There are also a fair few duplicates in there.
Is there any way of just creating a list of the first 3 chars of the list, removing duplicates and then basnig the validation on this?
I am now wanting to create some validation based on the first 3 letters, so I have created a named range that covers off the formula for the first 3 chars. However, to get the formula to work covering all data, I have copied it down a fair way so when I base the validation on this it has hundreds of blanks. There are also a fair few duplicates in there.
Is there any way of just creating a list of the first 3 chars of the list, removing duplicates and then basnig the validation on this?