i can't remember if i have always had a "Ref" sheet, but that is supposed to work with the "1" sheet. dredwolf was the one who pointed to me that the formulas in "1" had some errors & i have rectified that. thanks, dredwolf. the latest file now for that sheet should work fine.

@venkatpvc:
you're very welcome. =) hope it helps!