Hi,

I can give you an idea of how to do it.

Suppose your data is in the range A2:B5

Ashish 0
Mathur 1
Ashish 0
Satish 2

In cell C2, enter the following array formula (Ctrl+Shift+Enter)

=IF(MIN(IF((B2:B50)*(B2:B5MAX($C$1:C1)),B2:B5)) 0,MIN(IF((B2:B50)*(B2:B5MAX($C$1:C1)),B2:B5)),"" )

Copy this formula down. you will now get all numbers which are greater than 0

In cell D2, enter the following formula

=INDEX($A$2:$B$5,MATCH(C2,B2:B5,0),1) and copy down

This should provide you some idea of how to proceed

Nevertheless if you still need some help, please do not hesitate to write an
e-mail to me at

Regards,

"Jim" wrote:

Thanks for the help

On sheet one I have a list of items I inventory. The list is by vendor and
I cannot use a sort because I would lose vendor order. Below is an example
of the data I work with.

I would like to draw out onto sheet two the data that has a count only. For
example, below the line that has 44, 50, 101, 120 and a couple 0s. The only
data I would like to show on sheet two are the rows that have 44, 50, 101 and
120.

Vendor Name
627298 4.5ft Stainless Steel Inventory 44 $15.75 $693.00
627304 5.25ft Stainless Steel Inventory 50 $20.25 $1,012.50
627311 Copper Coated Inventory 101 $14.50 $1,464.50
627328 Silver Coated Inventory 120 $14.50 $1,740.00
21-0362 Swirl Bistro Table Inventory 0 $500.00 $0.00
21-0162 Swirl Dining Armchair Inventory 0 $500.00 $0.00

Another question I have is once the data is pulled over to sheet two, is
there an easy process for removing the empty rows so the data shows without
lines, or like the following:

Vendor Name
627298 4.5ft Stainless Steel Inventory 44 $15.75 $693.00
627304 5.25ft Stainless Steel Inventory 50 $20.25 $1,012.50
627311 Copper Coated Inventory 101 $14.50 $1,464.50
627328 Silver Coated Inventory 120 $14.50 $1,740.00

Thanks