Print min/max from dynamic data

Copper Contributor

Hi Folks,

Request your help in finding the "Minimum and Maximum" numbers of the given set kind of blocks. For ex, as and when the formula finds a number in Column 'G'(in this case 33878.07), it should print (in column J&K) the minimum and maximum numbers from the Yellow block. Similarly when it finds a value in 'I' column(in this case 33670.66), it should print (in column L&M) the min/max numbers from the pale red block, and the same should go on with the remaining data blocks. Data is dynamic, so neither the data nor it's places are constant.  Appreciate your help, thanks in advance.

2 Replies

@NV 

 

On your previous case (Find Minimum Value from a dynamic range) you wrote I'll test it out and keep you posted the update. So far no update (there's a link to Mark as solution at the bottom of each reply you get) 

I updated the status as that solution is not fulfilling my requirement. Please help with this requirement.