Hey everyone! I must be doing something wrong but for the life of me, I can't figure out what it is. I have cell M21 with =MODE(B2:F3500). Now in M22 I have =MODE(IF(COUNTIF($M21:M22,$B$2:$F$3500),"",$B$2:$F$3500)) to find the next largest number which I make an array via the CTRL-Shift-Alt Enter which brings up "0" into that cell. Am I doing this wrong or is there something I'm missing? TIA
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Array not changing cell number when dragged down
- Thread starter jarhead58
- Start date
Excel Facts
Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
