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