Very helpful video!

Exactly what I was looking for, thank you!

Clear and to the point, thank you, very helpful!!!!

It's not really "how many 54, 48 and 62" are in the list, rather, how many "numbers" are there in between. Example: data_array: 1 to 10, bins_array: 2,5 and 7. The answers are: (2, 3, 2) 2 (numbers below 2) 3 (numbers between 5 and 2) 2 (numbers between 7 and 5) *note: bins array need not be sorted, Frequency function auto-sorts the bins_array.

@OfficialMoin

4 жыл бұрын

I am confused dude, are you sure?

@intensemaster

3 жыл бұрын

@@OfficialMoin I just tried it, and mine won't work, so he seems to be correct

@nikhatkamal8908

Жыл бұрын

You are absolutely right!! However, as an another example, if you want to see how many times certain numbers occurred in a list, we have to first find all the unique numbers in that Data array, put them in the adjacent column as Bin array, then in the adjacent column use frequency function and calculate the frequency for the bin array. Strangely, I found if I try to find the frequency of only some numbers in the data array, the answer never comes rightly. To get a correct answer, the complete range of unique numbers listed in data array should be necessarily in the bin array. I tried to remove my confusion but non of the videos explains. Do you have any explanation for this? Thanks

I've been looking for this. Thanks for your help ! ❤️

@BarbHendersonconsulting

3 жыл бұрын

Glad I could help!

Excellent video! Thank you.

Not a function I've used before really, so thanks for demonstrating Barb 👍

@BarbHendersonconsulting

Жыл бұрын

You’re welcome 😊

Thank you, miss Barb! This was really helpful, have a great day and take care!

@BarbHendersonconsulting

2 жыл бұрын

You are so welcome!

Thank you Mam.U saved my day!

Thank you so much, no one else explains it as concise or practically accurate as you

@BarbHendersonconsulting

5 ай бұрын

Glad it was helpful!

Miss, you have just earned the gratitude of a not inconsiderate number of Romanian students.

@BarbHendersonconsulting

Жыл бұрын

Thank you for your kind words

Perfect video ,thanks for that ,good bless you !

@BarbHendersonconsulting

3 жыл бұрын

Thank you too!

Very helpful. Have a wonderful day.❤

@BarbHendersonconsulting

3 жыл бұрын

Thank you! You too!

Very nice. Thanks!

Really helps my homework. Thank you!!

@BarbHendersonconsulting

3 жыл бұрын

Glad to hear that!

Learning excel for my actuarial exams...this one helped alot.... thankyou

@BarbHendersonconsulting

9 ай бұрын

happy to help

ctrl shift enter.. who would have thought that was the magic action I was missing. Thanks!

@BarbHendersonconsulting

3 жыл бұрын

It will save you some time

Glad I found this. Thank you.

@BarbHendersonconsulting

3 жыл бұрын

Glad it was helpful!

BARB IS THE GOAT 💪💪💪💪💪

@BarbHendersonconsulting

9 ай бұрын

thanks!

Thank you very much for the video. It's pretty clear and well explained, but I had a problem when I pressed Ctrl + Shift+ Enter. An error window appeared saying incorrect formula.

@BarbHendersonconsulting

2 жыл бұрын

that is funny, I use that all the time!

Thank You Barb!!

@BarbHendersonconsulting

3 жыл бұрын

You are so welcome!

Thank you!

I wasn't sure what the bins argument meant three minutes ago, but now I do! Thank you!

@BarbHendersonconsulting

3 жыл бұрын

Thanks for watching

7 years ago, But still helping. thank you!

@BarbHendersonconsulting

10 ай бұрын

Glad it helped!

Thank you this is very helpful

@BarbHendersonconsulting

2 жыл бұрын

You're welcome!

Thank you you have saved my life with this explanation :-)

@BarbHendersonconsulting

Жыл бұрын

Happy to help!

thank you, very helpful

@BarbHendersonconsulting

6 ай бұрын

Glad to hear that!

Bless you, Barb!

@BarbHendersonconsulting

10 ай бұрын

thank you

You just helped me, thanks

@BarbHendersonconsulting

7 ай бұрын

Happy to help

You are the best thank you!!!

@BarbHendersonconsulting

3 ай бұрын

You're welcome!

Thank you very much 🙏🏻

@BarbHendersonconsulting

4 жыл бұрын

You are very welcome

I was wondering why the values werent populating in all cells, I was missing the ctrl+shift+enter. thanks for the info!

@BarbHendersonconsulting

8 ай бұрын

the ctril-shift-enter is a very useful trick

AWESOME! Thanks!

@BarbHendersonconsulting

Жыл бұрын

Happy to help!

Thank you very much ❤️

@BarbHendersonconsulting

3 жыл бұрын

Welcome!

Thank You so much

@BarbHendersonconsulting

3 жыл бұрын

You're most welcome

THANK YOU!

@BarbHendersonconsulting

Жыл бұрын

You're welcome!

Thank you 🌷🌷🌷

@BarbHendersonconsulting

3 жыл бұрын

You're welcome 😊

Hey dear..thnk..love from india!

@BarbHendersonconsulting

3 жыл бұрын

Welcome!!

THANK YOU

@BarbHendersonconsulting

Жыл бұрын

welcome!

Hello sir i have a wuestion sir how did you record the whole excel worksheet with the options you have selected i have tried but it showing only cursor but not the option that we are selecting from the upper bar

@BarbHendersonconsulting

Жыл бұрын

I did not record the macro, I just used the Fréquence function

Thanks a ton

@BarbHendersonconsulting

2 жыл бұрын

Most welcome!

Appreciate it.

@BarbHendersonconsulting

Жыл бұрын

thanks

You Saved MY ASS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! I have been on this since morning THANK YOU!!!!!!!!!!!!

@BarbHendersonconsulting

Жыл бұрын

happy to help

So whats the difference between this and the COUNTIF function

@sparklingrose8374

4 жыл бұрын

I dont have the frequency option. So how?

Can this be considered as countif formula?

@BarbHendersonconsulting

11 ай бұрын

similar but different

Thanku 😀😃

@BarbHendersonconsulting

2 жыл бұрын

Thank you too

thanks

@BarbHendersonconsulting

Жыл бұрын

Welcome

How to find frequency for the range of values say 5 to 10

@BarbHendersonconsulting

2 жыл бұрын

follow the steps in the video

hvala kraljice

@BarbHendersonconsulting

3 жыл бұрын

Nema na čemu

How to do this with 2D data?

@BarbHendersonconsulting

Ай бұрын

not sure, I have never tried

Can someone please tell me how is this function different from "COUNTIF"?

@karikrummi4222

3 жыл бұрын

easier to find many

I wonder if one could not use a COUNTIF function instead.

@BarbHendersonconsulting

4 ай бұрын

You certainly could but this give you another option

2:25 Did you mean two thousand six hundred twenty-nine? lol

@BarbHendersonconsulting

3 жыл бұрын

That is correct

not working

@BarbHendersonconsulting

8 ай бұрын

try the steps again

Phyllis? Phyllis Vance from the Office? Sadness? Is that you?

@BarbHendersonconsulting

3 жыл бұрын

It is still Barb Henderson

eero unt on munn

@BarbHendersonconsulting

3 жыл бұрын

got it

Audio could've been better

Thank you!

Thank you!

@BarbHendersonconsulting

4 ай бұрын

You're welcome!

Thank you!

@BarbHendersonconsulting

2 жыл бұрын

Welcome!

Thank you!

@BarbHendersonconsulting

2 жыл бұрын

You're welcome!

Thank you!

@BarbHendersonconsulting

Жыл бұрын

Always welcome!