I have names of customers in column A for 2010. I have names of customers in column B for 2011. I have column C open for names of customers that were in 2010 and 2011. What is an array function to give me this information in column C and not leave any spaces between lines
Do you have to use a formula? On the data tab there is a Remove Duplicates tool. Put all customers from 2010 and from 2011 in column C and then run the tool.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Dave's suggestion would give you a distinct list of customers from either 2010 or 2011. Is that what you want, or do you only want a list of customers who appeared in both 2010 and 2011?
Correct Colin. I need to show what customers appeared in both 2010 and 2011. See example.
Last edited by Heather.Taylor; 09-30-2011 at 04:43 PM.
Sorry I misinterpreted your original request. This formula is the best way I know how:
It will display the names that match and blanks for any names that don't match.
=IF(ISERROR(MATCH(A2,$B$2:$B$5,0)),"",INDEX($B$2:$B$5,MATCH(A2,$B$2:$B$5,0),1))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Heather.Taylor 
Register To Reply
Bookmarks