Hide value in Listbox if 2nd Column = 0

[f2e4]

Hey guys,

I have a listbox that is populated from a pivottable.

The ListFillRange for the Listbox is a Dynamic Named Range for the 1st column of the Pivottable.

I have the listbox set up to show both columns of the pivottable.

Some of the items listed have a sum of 0 in the second column.

Is there a way to hide this item if the value in the second column = 0.

Thanks

F

[Bob Phillips]

I would suggest building an array of valid items and then load the array.