Frequency Function

  • Thread starter Thread starter gorg
  • Start date Start date
G

gorg

No matter how many time I try or different ways I try, I
keep getting a #Name? error when using Frequency. I used a
named range and also used the Cell references. Any help
would be greatly appreciated. Now, I'm going to give blood
which obviously will be less painful.
 
No matter how many time I try or different ways I try, I
keep getting a #Name? error when using Frequency. I used a
named range and also used the Cell references. Any help
would be greatly appreciated. Now, I'm going to give blood
which obviously will be less painful.
Click to expand...

Perhaps you are misspelling something? Type frequency in small letters. If
Excel recognizes that function, it will see that it gets capitalized in the
formula window, narrowing your problem to your arguments.

If Excel does not capitalize frequency, then perhaps you have a non-English
version of Excel and frequency is spelled differently?


--ron
 
Hey there,
I would be willing to bet that your problem lies in the fact that you
are not using an array formula. Here's how to fix. After entering the
frequency formula, select the formula, press CtrlShiftEnter all at
once. This will bracket it . Should work
 
Back
Top