skipp blank cell

S

Sanjiv

for example :
I write a formula : =if($m9=25,$j9,"")
and copy the same A!:A7

ouput of the above :
A
1 100
2
3 200
4 300
5
6
7 500

How can I, using same formula as above, get an output as :

A
1 100
2 200
3 300
4 500
5
6
7

lindly help, thnx.
Sanjiv
 
S

Sanjiv

Thank you Gary, for your response, I will surely try to use the formula as
suggested in the link, However can u also pl suggest a simplified alternate'.
Thnx Again.
 
S

Spiky

Thank you Gary, for your response, I will surely try to use the formula as
suggested in the link, However can u also pl suggest a simplified alternate'.
Thnx Again.
Click to expand...

You could Sort to move blanks to the bottom, not exactly get rid of
them, but it might look like it.

You could Autofilter to hide blanks.

You could use Advanced Filter to ignore blanks.
 
Top