Excellent analysis Alan. The way of going through the descriptive range with the TEXTBEFORE function is very brilliant.
@Computergaga
10 ай бұрын
Thanks Ivan. Much appreciated.
@nadermounir8228
10 ай бұрын
Very nice and well explained video 📹 Thank you Alan for your hard work :) 😊
@Computergaga
10 ай бұрын
Thank you Nader. My pleasure.
@Seftehandle
10 ай бұрын
Gorgeous! Love it!! Add histogram i. The title and dynamic arrays
@Computergaga
10 ай бұрын
Thank you 👍
@Seftehandle
10 ай бұрын
Thank you@@Computergaga !!! Long time I haven't seen new functions + chart + under 5 mins. So refreshing!
@willemmulder7304
9 ай бұрын
Hi Alan, great video! A question. Is the -1 in cell H3 really necessary? It also works without it.
@Computergaga
9 ай бұрын
Thank you, Willem. The -1 is used to subtract 1 from the first number in the range. So, 60 becomes 59 and FREQUENCY checks if a number in that range is >59. If you change one of the scores to 60, you will notice that it only appears in the 60-69 range if the -1 is in place. I hope that makes sense.
@willemmulder7304
9 ай бұрын
@Computergaga Thank you! I tested the options and now I understand the difference.
Пікірлер: 11