Looking up data based on text and a date

huffywork

New Member
Joined
Mar 24, 2014
Messages
6
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?
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Watch MrExcel Video

Forum statistics

Threads
1,114,561
Messages
5,548,743
Members
410,868
Latest member
Dhanas
Top