Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i find multiple matches of one data item in an excel range
I have one limited database list of store locations with store numbers and
addresses. We often will have multiple store numbers at the same address. I'd like to use our master list of all stores to determine which stores share the same address as those on the limited list. How do I do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i find multiple matches of one data item in an excel range
This might help you
http://www.cpearson.com/excel/Duplicates.aspx "DivaHouston" wrote: I have one limited database list of store locations with store numbers and addresses. We often will have multiple store numbers at the same address. I'd like to use our master list of all stores to determine which stores share the same address as those on the limited list. How do I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Data from one sheet that matches | Excel Discussion (Misc queries) | |||
item # in one sheet want to pull data that matches from other tab | Excel Worksheet Functions | |||
formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
How do I tell Excel to find the last item in a column? | Excel Discussion (Misc queries) | |||
INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then replacing 0 with another number in another cell | Excel Worksheet Functions |