Excel Array Formula Series #8: FREQUENCY function

[latinotorino]

Hi there, first of all many thanks for this channel that I find one of the best in the tube. There is a little thing that I don't understand in this video. The second and third table should behave in the same way when you modify the values in the array "Oil Change Times", but only the third one seems to be modify when you put "-2" in the array. how come that happened?

All me best wishes

[ExcelIsFun]

@latinotorino , what minute mark are you referring to?

[latinotorino]

@ExcelIsFun, I'm sorry, my mistake, there is nothing wrong in the video. I just misunderstood something.

Cheers

[ExcelIsFun]

@latinotorino , Okay!!

[ponkyZZz]

Thx man! So hardCore!

[ExcelIsFun]

@ponkyZZz , You are welcome!

[TheGoalie37]

THANK YOU SO MUCH! 

[ExcelIsFun]

@TheGoalie37 , I am glad that it helped!

[dragonuorgasmatic]

THAAAANK YOU  ! this frequency Function bugged me alot!

[ExcelIsFun]

You are welcome!

[matson10081709]

Thank you, it's really useful, more understandable 1000 times than my teacher :D

[ExcelIsFun]

I am glad that you liked the video!

[JJTheBigDog]

@ExcelIsFun and 1000 times more helpful then excels help function!

[ExcelIsFun]

I am glad that it helped!

[beemerdi]

Thanks for your help and for keeping it simple. Keep up the good work!

[ExcelIsFun]

You are welcome!

[alliebobz]

This has really helped me figure something out that I have been stuck with for a little while. Your enthusiasm for the subject is obvious and I will definitely be subscribing to your channel so I can consult you when I next hit a wall!

[ExcelIsFun]

I am glad the video helped!!

[ShootBogans]

THANK YOU

[ExcelIsFun]

You are welcome!

Here is a video that goes into WAY more detail about what can be done with the FREQUENCY function:

Excel Magic Trick 627: FREQUENCY Array Function (10 Examples)