Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Thanks for any help you may be able to provide.
Yesterday there was a post about counting unique values. The reply had a link to a frequency formula - http://tinyurl.com/5rloz The OP never replied back so it's unknown if that formula worked. I'm always interested in learning new techniques so I played around with this formula. The problem is this formula doesn't work. I copied the formula to a worksheet (had to remove some junk that got embedded from the Google archives) but when I tried it I got an error message that said "not enough arguments for this function". The formula doesn't include the Bins_Array argument for the Frequency function. So I added that argument as an empty range - Z1:Z5 with nothing in that range. According to Excel help, If bins_array contains no values, FREQUENCY returns the number of elements in data_array. Well, that did not work. I kept getting results of 0. Can anyone help me understand that formula and how it works? Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |