Preventing a listing of duplicate records
 

One one tab of a spreadsheet, I have a listing of investments (eg Column A is
principal, B is Invest. Broker, C is Rate, D is Maturity Date...etc)
On a seperate tab of the spreadsheet, I'd like to be able to pull a listing
of all investments that have a specific maturity date.
I've tried doing this with Vlookup, but its only giving me the result of the
first investment that matches the maturity date criteria.
How can I do this without using the Filter function?

Preventing a listing of duplicate records
 

One option is using a pivot table, formating it with the fields that you want
to be part of the list in the rows, the Maturity Date in the page area and
any field in the data (if you just need the list). You will have a drop down
to select the different Dates and the rows will change accordingly.
The issue is what you would like to do later with the list, the pivot table
format may not fit in what the list will be used for.

Hope this helps,
Miguel.

"Brian" wrote:

One one tab of a spreadsheet, I have a listing of investments (eg Column A is
principal, B is Invest. Broker, C is Rate, D is Maturity Date...etc)
On a seperate tab of the spreadsheet, I'd like to be able to pull a listing
of all investments that have a specific maturity date.
I've tried doing this with Vlookup, but its only giving me the result of the
first investment that matches the maturity date criteria.
How can I do this without using the Filter function?