Intermediate
New Member
- Joined
- Apr 27, 2012
- Messages
- 13
Hi,
Say I have a 3x3 grid containing numbers 1-9, populated in rows from left to right. I need two formulae that will tell me the column and the row of any number, eg. "8" = column 2, row 3.
<tbody>
</tbody>
Thanks in advance for any help you can offer.
Much Appreciated.
Say I have a 3x3 grid containing numbers 1-9, populated in rows from left to right. I need two formulae that will tell me the column and the row of any number, eg. "8" = column 2, row 3.
1 | 2 | 3 |
4 | 5 | 6 |
7 | 8 | 9 |
<tbody>
</tbody>
Thanks in advance for any help you can offer.
Much Appreciated.