querying excel spreadsheets like database

[corrie]

I'm making a payroll journal, it has a column for the names, and the
the cheque amt, cheque no., and some other stuff.

In a separate sheet I need to pull up individual information pe
employee and total.

Eg.
Payroll Journal:
Name: cheque amt: cheque no: date:
jane doe 2000.00 0001 01/01/01
john doe 1500.00 0002 01/01/01
jane doe 1800.00 0003 15/01/01

Employee Details:
Name: cheque amt: cheque no: date:
jane doe 2000.00 0001 01/01/01
jane doe 1800.00 0003 15/01/01

total: 3800.00

-----------------------------------------------------------------------------
I am having issues, I can't use a lookup based on entering a name
because it will just give me duplicates of the first one it finds th
entire way down the details page. I need to know how to take just th
rows for that employee, and the individual details.

Any suggestions

 

[Frank Kabel]

Hi
I would use Data - Filter and Data - subtotals for this. Though it is
possible using some array formulas I would recommend to use the
filtering functionality of excel