Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FREQUENCY FORMULA
I have this formula in Excel 2003.
=MAX(FREQUENCY(IF(AM$67:AM$2001=AN4,ROW(AM$67:AM$2 001)),IF(AM$67:AM$2001<AN4,ROW(AM$67:AM$2001)))) I am trying to calculate the number of runs located in column AM. Cell AN4 equals the number 2 that I am trying to figure out occurred so many times as part of a run not the number of times it occurred using COUNTIF. I used a formula I found online that worked for them perfectly. Won't work for me. I get #VALUE! instead. What am I doing wrong? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FREQUENCY FORMULA
Hi,
Am Fri, 6 Nov 2015 23:03:59 -0800 (PST) schrieb rhhince: I have this formula in Excel 2003. =MAX(FREQUENCY(IF(AM$67:AM$2001=AN4,ROW(AM$67:AM$2 001)),IF(AM$67:AM$2001<AN4,ROW(AM$67:AM$2001)))) I am trying to calculate the number of runs located in column AM. Cell AN4 equals the number 2 that I am trying to figure out occurred so many times as part of a run not the number of times it occurred using COUNTIF. I used a formula I found online that worked for them perfectly. Won't work for me. I get #VALUE! instead. What am I doing wrong? Thanks. try: =COUNTIF(AM$67:AM$2001,AN4) Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FREQUENCY FORMULA
On Saturday, 7 November 2015 04:17:42 UTC-6, Claus Busch wrote:
Hi, Am Fri, 6 Nov 2015 23:03:59 -0800 (PST) schrieb rhhince: I have this formula in Excel 2003. =MAX(FREQUENCY(IF(AM$67:AM$2001=AN4,ROW(AM$67:AM$2 001)),IF(AM$67:AM$2001<AN4,ROW(AM$67:AM$2001)))) I am trying to calculate the number of runs located in column AM. Cell AN4 equals the number 2 that I am trying to figure out occurred so many times as part of a run not the number of times it occurred using COUNTIF. I used a formula I found online that worked for them perfectly. Won't work for me. I get #VALUE! instead. What am I doing wrong? Thanks. try: =COUNTIF(AM$67:AM$2001,AN4) Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional Thanks. I will do that. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with frequency formula | Excel Discussion (Misc queries) | |||
Frequency formula | Excel Worksheet Functions | |||
Frequency Formula | Excel Worksheet Functions | |||
Frequency Formula | Excel Discussion (Misc queries) | |||
Frequency formula | Excel Worksheet Functions |