View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mary Mary is offline
external usenet poster
 
Posts: 190
Default retrieve duplicate values from arrays

My spreadsheet contains the following:
A B C D
1 123 xxxx x1x1 12345
2 101 yyyy y1y1 23456
3 123 zzzz z1z1 34567
4 215 aaaa a1a1 89100

In another spreadsheet, I want to get all data using column A as the
criteria including those with duplicate values and not just the first one. In
effect I want my other worksheet to show:
A B C D
1 123 xxxx x1x1 12345
2 123 zzzz z1z1 34567