If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
querying excel spreadsheets like database
I'm making a payroll journal, it has a column for the names, and then
the cheque amt, cheque no., and some other stuff. In a separate sheet I need to pull up individual information per 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 the entire way down the details page. I need to know how to take just the rows for that employee, and the individual details. Any suggestions? --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
querying excel spreadsheets like database
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 -- Regards Frank Kabel Frankfurt, Germany I'm making a payroll journal, it has a column for the names, and then the cheque amt, cheque no., and some other stuff. In a separate sheet I need to pull up individual information per 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 the entire way down the details page. I need to know how to take just the rows for that employee, and the individual details. Any suggestions? --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|