LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Brian Connolly
 
Posts: n/a
Default Searching a list with repeat entries and creating a sum

I have an array (single column) of part codes with an assciated number of
parts in an adjacent column. Given that there may be duplicate entries in the
part code column, how do I create a new column of unique part codes (i.e each
part code listed only once in the column) and a second colum with the nummber
of parts associated with that part code.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 09:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"