Hide cells with no display

[tondrey]

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?

[NBVC]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.