I just found that, if you use keyboard shortcuts Ctrl + R or Alt + H + F + I + R with MAX formula in a table, the auto-filled cells would be identical to the original cell. Copying and pasting formula also render the same result. However, if you drag from the original cell using the mouse, the auto-filled cells would have the maximum result of their columns, as most of us would desire.
Does anyone know how to autofill MAX formula with only the keyboard that renders maximums results of different columns or rows?
Bookmarks