Find the Max and Min value in multiple set of cells containing streaming data using UDF

I have a workbook that get live data from a streaming server, i found this thread that can do the trick, http://www.excelforum.com/excel-prog...using-udf.html, but it cannot get the various set of cells to work using UDF,

I have live data in cell O48, O49, O50, .... each having different values, if the current values are like this, O48 = 1.23, O49 = 3.35, O50 = 120.25, and keeps changing,

what is the code to get the Max of O48 and enter to L48 and min to M48,
Max of O49 and enter to L49 and min to M49,
Max of O50 and enter to L50 and min to M50, .........

result values of the cells is something like this
L48 = 1.28, M48 = 1.20,
L49 = 3.55, M49 = 3.12,
L50 = 125.20, M50 = 118.50,
......

Hi, the code in formula is MAX and MIN if you use VBA then you use WorksheetFunction.Max or .Min

It's not that simple because you cannot compare L48 to istself and to O48 as well as M48 to L48
I have no idea where your live data comes from and if the workbook you use has any macros, what version of Excel.
So if you've got no idea of code (I think you mean programming) then it won't be that easy.
Try this link so you get an idea how it can work
http://www.contextures.com/excelminmaxfunction.html