Example 2x2 matrix:
When referencing a specific element in a 2D matrix, I believe the standard is to refer to an element by row then column. So for example, (1,2) above is "Bun".
However, in Excel's default configuration (A1 Notation), it's column then row (with column in letters). So for example, the index for "Bun" would be "B1" (instead of "1B").
One would think that the two would follow the same convention to avoid confusion? Or am I missing something? Can someone explain why it's like this?
(edited for clarity)
Ant | Bun |
Cat | Dog |
When referencing a specific element in a 2D matrix, I believe the standard is to refer to an element by row then column. So for example, (1,2) above is "Bun".
However, in Excel's default configuration (A1 Notation), it's column then row (with column in letters). So for example, the index for "Bun" would be "B1" (instead of "1B").
One would think that the two would follow the same convention to avoid confusion? Or am I missing something? Can someone explain why it's like this?
(edited for clarity)
Last edited: