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