skipp blank cell

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

See:

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


--
Gary''s Student - gsnu200797


"Sanjiv" wrote:

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

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.

"Gary''s Student" wrote:

See:

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


--
Gary''s Student - gsnu200797


"Sanjiv" wrote:

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

On Jul 31, 10:58 pm, Sanjiv wrote:
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.

"Gary''s Student" wrote:
See:

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

--
Gary''s Student - gsnu200797

"Sanjiv" wrote:

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

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.