| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Select Distinct Maximums
Hi all
I need to extract from a workbook the rows who are the maximums, by a field B, between those having the same field A (numeric, length 12). I.E: Field A | Field B 800000111111 | 27000 800000111111 | 4000 800000222222 | 5000 800000222222 | 8000 800000222222 | 15000 800000222222 | 2000 800000222222 | 15000 800000222222 | 9000 800000222222 | 9000 800000333333 | 4500 800000333333 | 2700 800000333333 | 9800 I want to get a new sheet with Field A | Field B 800000111111 | 27000 800000222222 | 15000 800000333333 | 9800 Thanks for help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SELECT large amount of data in a worksheet | Excel Discussion (Misc queries) | |||
| Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
| Select Rows dependant on certain field data | New Users to Excel | |||
| Conversion | Excel Worksheet Functions | |||
| Select all data, multiple rows | Excel Discussion (Misc queries) | |||
Threaded Mode
