Hi ALL thanks for your reply..i have the formula used in sheet2 to calculate unique rows and i want the result to be displayed on D10 cell in sheet 1 .. can any one help.. thanks