Capturing Individual High and Low Values of cells on multiple lines

Hello

I am a new member here, specifically because I am looking for help with a problem. Although from what i have seen there is loads of information and resource here so will be sticking around now that I have found the place.

I have a need to capture the high and low values of a cell which has streaming data in it. I have found a solution from this site which is a great start in this thread https://www.excelforum.com/excel-pro...ml#post3534977

This is good although I need to take it one step further, I need to capture the individual high and low values of a particular field over multiple rows. where as this works well with recording one cell or the high low values from a range of cells.

I know worse case scenario I can create multiple functions, one for each row I need to record the values from, but was wondering if there was a more elegant solution, I have tried to somehow pass in the cell reference to make the variable name which stores the value unique to each row, but I have not succeeded.

Does anyone have any ideas ?

thanks

J

Hello

Thanks for the quick responses, I really appreciate the help.

I have attached an example of what I am trying to achieve.

column A will have values which are streaming from a separate application, column C and D are where the high and low values are stored,with a UDF I have got from another user on this forum.

if we just focus on row 2 for the moment and enter values into "A2" you can see that the high and low values are stored in "C2" and "D2".

the issue is when you enter a value in to "A3" it pulls a value down from row 2.

I think this is because the variables used in the UDF are not unique to the row so when the code is called it has stored values from the other instances of the function.

I can get around this by creating 40 individual functions and using one unique function per row but that will make maintenance a pain in the behind.

I hope that makes more sense and the example file helps.

Guys

I really appreciate both your answers they both do what I am looking to achieve.

I have starred both answers as i will more than likely use both options in different workbooks.

Thanks very much for taking the time to help me out, In the unlikely event that I can offer help to either of you then just let me know

J