Thread: Display only cells with data

I have a large array of cells (G47:BR155) that all contain IF functions
One example is
=IF(COUNTIF(G$23:G$45,F47),G$22,"")

Each cell is a little different, but most of them are blank because of the value_if_false ("")

So what I have is a large array of cells with a small percentage actually showing any value. In most cases, there are only 3 cells between G and BR that show a value.

What I would like to be able to do is to show those 3 cells that return a value (G22 in my example) next to each other.

Another way to put it is I would like the cells that return no value ("") to be hidden so I can quickly see the cells that return a value (value_if_true)

Does this make sense?

Hi tondrey,

You can use the SMALL function, to display values next to each other.

Open the attached document to see an example.

Orlando Mezquita