Searching a list with repeat entries and creating a sum

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Brian Connolly (Connolly_at_discussions.microsoft.com)
Date: 02/03/05 

Date: Thu, 3 Feb 2005 13:07:03 -0800

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.

Relevant Pages

  • Re: Can you use Excel formulas in Access VBA?
    ... I'm not really familiar with the Trend function, but looking at the help in ... Excel, you need to pass it a set of values, not just individual values: ... If the array known_y's is in a single column, ... If the array known_y's is in a single row, then each row of known_x's is ...
    (microsoft.public.access.modulesdaovba)
  • Re: Selection.count isnt working
    ... If this is a single column range, the number of cells, ... if the end result is to pick up the data in the range to the array ... cvec = Range.Value ... sStr = sStr & vbNewLine ...
    (microsoft.public.excel.programming)
  • Re: transferring matrix to range
    ... The OP indeed was "how to put a *matrix* (multiple array) to a range and ... But I also had a problem with an array consisting of a single column. ... Dim rng As Variant, arr As Variant ...
    (microsoft.public.excel.programming)
  • Re: MATCH, INDEX and VLOOKUP with Arrays
    ... than a single column. ... When using XL functions in VBA, you need to first understand how they ... > the array manually and the array is sorted by the first column. ... > value is in a variant variable and the 2-Dimensional array is a variant redim ...
    (microsoft.public.excel.programming)
  • a text array formula
    ... I have a contact data in a specific vertical index in a single column. ... I wanted to set up an array forumla to automatically transpose the data ...
    (microsoft.public.excel.worksheet.functions)