Extracting specific rows from a large spreadsheet

**MelindaCapri** · 09-04-2012, 12:05 PM

Hi all,

I have a spreadsheet with 15 columns and over 3000 rows with duplicate names. I have used a pivot chart to narrow down the rows of information I need, somewhat. Now I have a list of 300+ names, but I need the date column for these 300 names ONLY. I cant figure out how to get it on the pivot table - I believe vlookup would help but not very familiar with how to use it.

For example: List of animals at the zoo and their birthdates; I have found that I need a specific 20 of their birthdates.

**arlu1201** · 09-04-2012, 01:03 PM

It will be good if you explain with the help of a sample file -

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

**MelindaCapri** · 09-04-2012, 01:08 PM

Was thinking same thing ... here it is!

Thanks

**arlu1201** · 09-06-2012, 08:53 AM

You have duplicates in your main data (columns A to D), so vlookup will only pickup the data for the 1st instance.

How do you want to show the data in case of duplicates?

**MelindaCapri** · 09-06-2012, 09:33 AM

I would like the most recent date.

Ultimately, I want to find the highest score of each *10, *20,and *30 test code for each ID#; then the most recent date the test was taken.

I have made a pivot table to give me the max score of those 3 test codes for each ID#, and it will display the dates under each ID. Which is exactly what I want minus showing only the most recent date.

Example of what I would like is below; the pivot I have made is missing the "Most Recent Date" column

ID #..10..20..30..Highest Cumulative..Most Recent Date = Headers
333333 = Sub headers
3/17..162.....150
8/17......130
5/17......167...........479.................8/17
Without the dots