SEARCH COPY OF TEXT

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have an excel spreadsheet with names and addresses in columns On 3
different worksheets. Is there a way to have excel search the doc for same
entire data. ex:
Jane Doe
Joe Davis
Jane Doe _ Exel would see that and stop since there is a Jane Doe already
entered?
Please help I really don't want to ctrl -f 380 times to make sure..
Thanks to anyone that replies
 
So you have some kind of cell that's used for data entry and you want to check
if that name appears in any of those other 3 lists?

If I used A1 on Sheet1 as my data entry cell, I could put this in B1:

=if((countif(sheet2!a:a,a1)+countif(sheet3!a:a,a1)+countif(sheet4!a:a,a1))>0,
"Already exists!","Ok to use")

But I'm not sure what you're really looking for....
 

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

Cross Reference of Excel Workbook 1
Creating Text based chart and formula help? 1
converting column of text to text box for repetitive records 3
Export text of Search Results to Excel 1
Excel Puzzle: Tracking Change in Hours 6
Deleting rows with same address 2
need help please.... 10
Excel VBA Merge Workbook tables Central table 1

Back
Top