Pivottable Question

N

Nelson

Hi,

I have one problem of Pivottable as below:

Account IP Count of IP
a z 5
y 4
x 3
w 1
v 1
b z 3
y 3
x 1
w 1
v 1

I only want to list the count of IP >1 which is:

Account IP Count of IP
a z 5
y 4
x 3
b z 3
y 3

How I set in Pivottable?
Thank you.
 
Top