Validating of sorts

  • Thread starter Thread starter Dewi...
  • Start date Start date
D

Dewi...

I have a list of details in 'details sheet', I have a form (Called
'form') which is used to populate the 'details sheet'.

I have a 3 sheet called 'don't touch' :-), here is the validation data
for the form.

Can I do something like this, if so how?

details sheet, A3 colum is hobbies, i have many hobbies and more are
added, can I do something to look at A3 put the list into 'don't touch
sheet' and remove all duplicate entries so only one of each is there
for the validator to pick up.

Thanks
 
I have a list of details in 'details sheet', I have a form (Called
'form') which is used to populate the 'details sheet'.

I have a 3 sheet called 'don't touch' :-), here is the validation data
for the form.

Can I do something like this, if so how?

details sheet, A3 column is hobbies, i have many hobbies and more are
added, can I do something to look at A3 put the list into 'don't touch
sheet' and remove all duplicate entries so only one of each is there
for the validator to pick up.

Thanks
Click to expand...

can I look at a column, copy the results to another column and remove
duplicate entries?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My solution to looking up a column and make a validate list... 1
CONDITIONAL FORMATTING BETWEEN SHEETS 1
Conditional Formatting Tricky question 5
Auto data entry 2
Copy Data from One sheet to Different Sheets 1
Little problem 25
Excel Is this possible?? 3
Data Validation and drop-down list using IF, AND and what else? 8

Back
Top