Jul 27 2022 04:02 AM - edited Aug 02 2022 09:20 PM
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.
Jul 27 2022 11:46 AM
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)
Jul 28 2022 07:46 AM