Thread: Returning consolidated values from indexing.
View Single Post
  #2  
Old 07-09-2009, 10:08 PM
rylo rylo is offline
Forum Moderator
  
Join Date: 15 Jan 2007
Location: Brisbane, Australia
MS Office Version:2003
Posts: 4,092
rylo is very confident of their ability rylo is very confident of their ability rylo is very confident of their ability rylo is very confident of their ability
Re: Returning consolidated values from indexing.
Hi

One way to do this is to use an advanced filter. You don't give any details on your structure, or where you want to output the data, but try this.

1) Your example data is in the range sheet1!A2:B9
2) Sheet1!A1:B1 has your header data (eg H1, H2)
3) Sheet2!A1: H1
4) Sheet2!A2: tb
5) Sheet2!A3: H2

Select Sheet2!A1:A2
Data, Filter, Advancedfilter.
Copy to another location
List Range: Sheet1!$A$1:$B$9
Criteria Range: Sheet2!$A$1:$A$2
Copy To: $A$4
Unique records Only: selected
OK.

This will bring back the entries for tb.

HTH

rylo
Reply With Quote