| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find max value in one column based on another column
I searched the posts, but didn't find anything obvious that would work in my
situation. I have a list of part numbers in column A, and their revisions in column B. One part number can have 1 or more revisions. I'd like to find the latest revision for each part number in column A. My list looks like: PART NUMBER Revision 1120007 A 1120007 B00 5360120 A00 5360120 A01 5360120 D00 and so on I have 51,000+ rows of data, and would like to summarize by finding only the latest revisions of the parts- in this case it would be B00 for PN 1120007 and D00 for PN 5360120. I can probably boil down that 51,000 part number rows to 3,000 to 4,000. I sense it would be pretty simple, but I'm a relative novice when it comes to Excel. Any help would be greatly appreciated. Dave |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| How to find the most recent date in a column based on other column | Excel Worksheet Functions | |||
| Find and sum values based on a column search | Excel Discussion (Misc queries) | |||
| Find a time value in one column based on names in another | Excel Discussion (Misc queries) | |||
Threaded Mode
