Hi,

You have a problem here in your defintion of the problem, consider this
small example:

1 2 3
4 1 5
6 7 1
8 3 9

Do you want to hide the first three rows because 1 occures the most often
and is found on all three rows? You can't filter single cells, you can hide
entire rows or columns but not cells. You can suppress the display of the
value in a cell based on a condition, but that cell is still there and its
value remains.

The simplest way to find the most frequent items is
=MODE(A1:H1300)

However, Excel does not handle bimodal and trimodal distributions, so how do
you want to handle situations in which two different numbers are the most
frequent occuring the same number of times?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Haralambus" wrote:

hi,
I have data in 1300 rows and 8 columns (all numbers). How can I filter out
most used x values?

thanks