"Sheet1" is the assumed name of your source data sheet, as mentioned in my
response. Anyway, glad you got it up n working. Do take a moment to hit the
YES button in the earlier response though ...
--
Max
Singapore
---
"Zuo" wrote:
Max,

I manage to fix the formula. It had to do with the sheet 1 portion of the
OFFSET function. I deleted the sheet 1 and moved the formula to the same
sheet where the data is located. Thank you very much for your help.