View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dawna Dawna is offline
external usenet poster
 
Posts: 19
Default sorting data in columns

I guess more specifically what I'm looking for is to sort multiple rows in
these columns. (This data will be pulled monthly) I would like the code to
pull all the part numbers used over that period of time, and return a count.
Is there a link to information on how to write this code in VB?

"Jacob Skaria" wrote:

If you are only looking to get the count then use worksheet function COUNTIF()

With partnumber in cell D1

=COUNTIF(A:D,D1)

'VBA
Application.countif(Range("A:C"),Range("D1"))

If this post helps click Yes
---------------
Jacob Skaria


"Dawna" wrote:

I have a worksheet with 3 columns of part numbers. What I'm looking for is to
be able to sort the data and return a count for each part number. The same
part number could appear in any of the three columns. I'm new at this, and
any help would be greatly appreciated. Thank you in advance.

Eample: Part# 1 Part#2 Part#3
IHZ-1590 IHZ-1480 IHZ-1599
IHZ-1599 IHZ-1599 IHZ-1590

IHZ-1480 = 1
IHZ-1590 = 2
IHZ-1599 = 3