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?
|