| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select one entry per group
I have a column that contains product codes. Each product code may have
several rows of data but the product code stays constant from row to row within the group. Is there a way that I can do a vlookup to only pick up the product code only once from each group? (The product codes can vary from month to month so I don't want to hard code anything.) Example: A008 A008 A008 A008 A010 A010 A010 A012 A013 A013 A Total I would like to pull A008, A010, A012, A013 & A Total,...... Any help would be appreciated. -- AJ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to select group of 77 number | Excel Discussion (Misc queries) | |||
| Mandatory entry for a group of cells? | Excel Discussion (Misc queries) | |||
| Extract select group of numbers | Excel Discussion (Misc queries) | |||
| How to select group of drop down lists to align | New Users to Excel | |||
| Can I select and Group Autoshapes in Excel 97 ? | New Users to Excel | |||
![AJ[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
