skipp blank cell

[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

 

[Gary''s Student]

See:

http://www.cpearson.com/excel/noblanks.htm

 

[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.

 

[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.

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.