| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Converting column & row numbers to a cell reference
Hi!
Try these: =ADDRESS(10,2,4) = B10 =ADDRESS(5,10,4) = J5 Biff "Graham Tritton" wrote in message ... I need to convert the column and row numbers into a cell reference. EG. 2,10 converts to B10 10,5 converts to J5 Anyone have any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return cell reference from any column | Excel Worksheet Functions | |||
| Way To Copy Formula In Column Without Changing All Cell Numbers | Excel Discussion (Misc queries) | |||
| Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
| reference cell value from fixed column with variable row | Excel Discussion (Misc queries) | |||
| up to 7 functions? | Excel Worksheet Functions | |||
Hybrid Mode
