F febausa Member Jul 17, 2014 #1 {=FREQUENCY(ROUND(H162:BN162,2),ROUND(BP164:BP193,2))} I paste this formula in the worksheet but Excel no doing nothing. Please advise how fix this problem?
{=FREQUENCY(ROUND(H162:BN162,2),ROUND(BP164:BP193,2))} I paste this formula in the worksheet but Excel no doing nothing. Please advise how fix this problem?
N NARAYANK991 Excel Ninja Jul 17, 2014 #2 Hi , I assume you have pasted this formula in a worksheet cell , placed the cursor in that cell , pressed F2 to enter EDIT mode , and then pressed CTRL SHIFT ENTER , to enter the formula as an array formula. Can you confirm ? Narayan
Hi , I assume you have pasted this formula in a worksheet cell , placed the cursor in that cell , pressed F2 to enter EDIT mode , and then pressed CTRL SHIFT ENTER , to enter the formula as an array formula. Can you confirm ? Narayan