recent dates

I have a spreedsheet which tracks a teams performance. There are multiple entries for TEAM each with different date, number, subject AS SEEN BELOW A1 B1 B2 B3 TEAM DATE NUMBER SUBJECT MM03 01/20/14 1620744 DROP MIM01...

Good day. I have a puzzle that I know someone out there is able to help me with. I have a workbook where on one tab I have information about a city, and then 20+ additional pieces of information for each city in the same row. Each city has multiple entries stored here for history purposes. What...

Good day All, I am trying to derive a formula that will lookup ID#s then retrieve the recent date aligned to it. IDs will be repeated with different dates. I want to retrieve the most recent. Example: A B C 3406 3/1/12 4500 3/4/12 3406 4/1/14 3406 3/12/13...

I'm looking to find the 5 last data entries that meet a criteria. In this case its the name of a team. So when the team name is: TEAM A Return the last 5 fixture dates and corresponding information. DATA,FIXTURE,SCORELINE My table is presented as such: <tbody> Date Fixture Team Home Score...

Hey guys, First time post, but I have read a few posts and it looks like this board is incredibly helpful. I am trying to create a formula that will pull the most recent date given a specific ID. The snag is that there are several dates associated with each ID. I have built a formula that...

Hello, I'm brand new to this forum, and very stuck with excel, so any help wil be greatly appreciated. I have a workbook containing 36 sheets with info on individual birds, each with the bird ID as sheet name, and all with same format. Columns from A to G go; Date, Transmitter, Easting...

Hi, Novice excel user here but I'm trying to keep the data as is but insert 5 lines on the top to show the 5 most recent dates. I've tried SMALL function but I'm having a problem with the duplicate dates. I would like to pull up the 5 most recent dates, I guess sorted by the highest amount...