.. With that array formula that I have worked out (hope is OK),
do you see any problem, say speed in performing calculation
when I reach the expected 10,000 records,
considering that the array is reading the very first row till the
end row?

I'm not sure about the specifics in your case, Carlos, but I'd usually set
the calc mode to "Manual" for workbooks loaded with intensive calcs, and
press F9 key to calc when ready.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--