| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SEARCH COPY OF TEXT
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 |
|
#2
|
|||
|
|||
|
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.... LinzNac wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a formula in excel to automatically copy text fro. | Excel Discussion (Misc queries) | |||
| COPY TEXT BOX | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| Copy and Paste to a Text Box | Excel Discussion (Misc queries) | |||
| Newbie: How to search a text string from right | Excel Worksheet Functions | |||
Linear Mode
