Hi,
I have tw
Hi,
I have tw
Last edited by rexcel548562; 08-07-2022 at 08:34 AM.
L4 =IF(OR($L4<$G$5,$L4>$H$5),$L4,IF(OR($J5>$G$5,$J5<$H$5),$J5,$L4)) and drag down.
Similar for the other example.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi Sir oeldere,
Last edited by rexcel548562; 08-07-2022 at 08:34 AM.
Please try at K5
=IF(N(K4),IF(MEDIAN($G$5:$H$5,K4)=N(K4),J5,K4),J5)
Last edited by Bo_Ry; 07-26-2022 at 12:21 AM.
Hi Sir Bo_Ry,
Last edited by rexcel548562; 08-07-2022 at 08:35 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks