Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 477
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find Data from one sheet that matches Brian Shafer Excel Discussion (Misc queries) 1 October 19th 07 06:58 PM
item # in one sheet want to pull data that matches from other tab JerriH Excel Worksheet Functions 3 May 21st 07 09:50 PM
formula to sort a range so that it matches the exact rows of a column that is outside that range? steveo Excel Discussion (Misc queries) 1 June 18th 06 02:05 AM
How do I tell Excel to find the last item in a column? Rodman Excel Discussion (Misc queries) 2 September 8th 05 04:22 AM
INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then replacing 0 with another number in another cell Tourcat Excel Worksheet Functions 1 February 8th 05 06:26 PM


All times are GMT +1. The time now is 07:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"