Thanks for posting back ..
Go with whatever works well for you over there <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"TUNGANA KURMA RAJU" wrote in
message ...
Hi ! Max,No doubt Biff's multi cell array suggestion is very good,it has
taking lot of time for calculating cells,I tried it ,I used yours formula
with "if" that gives balnk for zero value cells.This one is faster than
Biff's multi cell array formula.My thanks to both of you.