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