Here are some problems that our users have asked and received explanations on
I'm trying to get a similar function to work on my excel.
=ARRAY_CONSTRAIN(ARRAYFORMULA(index('Contract Month Detail'!$E:$E,match(C6,'Contract Month Detail'!$N:$N,0))), 1, 1)
Solved by S. L. in 28 mins
how to use excel max if function? I get a value error for my If Function =IF(MAX(B2:M2<10),"E","")
Solved by G. H. in 11 mins
I need help writing a if function to flag all e-mail addresses that are not mail.ccsf.edu.
Solved by T. B. in 16 mins
can you explain why in the sales worksheet, vlookup function in column E range lookup is 0 while in column H the range lookup is true. what's the difference?
Solved by X. D. in 22 mins
Enter a function in the range J4:J8 to calculate the frequency of service ratings from 1 to 5 received by all restaurants
and Enter a function in cell G11 to calculate the correlation between columns C and E.