Hello, I know just the bare basics in Excel, but I really need some help.
I have a spreadsheet I fill out daily for invoices from my office. I need to be able to create quick reports that can do the following.
Take a single 'item' and give me multiple columns of the same row but the criteria is it must be the most recent date.
For Example.
Employee - Company - Rig - Work - Invoice # - Date - Equipment - Comments
I want to be able to pick one of these columns, and then get the last row based on date.
Example: I choose a rig name, and get the last date that rig name shows up on the spreadsheet showing all the information 'employee - company - invoice, ect'
Or I can choose Equipment, and find the last row date for that equipment. Letting me know where that equipment was used most recently.
Can you help me figure out how to do this?
I have a spreadsheet I fill out daily for invoices from my office. I need to be able to create quick reports that can do the following.
Take a single 'item' and give me multiple columns of the same row but the criteria is it must be the most recent date.
For Example.
Employee - Company - Rig - Work - Invoice # - Date - Equipment - Comments
I want to be able to pick one of these columns, and then get the last row based on date.
Example: I choose a rig name, and get the last date that rig name shows up on the spreadsheet showing all the information 'employee - company - invoice, ect'
Or I can choose Equipment, and find the last row date for that equipment. Letting me know where that equipment was used most recently.
Can you help me figure out how to do this?