Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell coordinate label place (r,c)
Add displayed information in a cell that has numbers within paranthesis like
"(2,-3)". Here is an example: -3 -2 -1 0 1 2 3 | 2 | 1 ----(1, -2) 0 -1 There would be "axis" numbers on the edge of a "map". Every cell in the map would display the location in the map as (row, col), like "(1,-2)" in the example above. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell coordinate label place (r,c)
Put this formula into cell B2, and copy to fill your table:
="(" & $A2 & ", " & B$1 & ")" I assumed that your labels are in row 1 and column A.... HTH, Bernie MS Excel MVP "XCell_Help" wrote in message ... Add displayed information in a cell that has numbers within paranthesis like "(2,-3)". Here is an example: -3 -2 -1 0 1 2 3 | 2 | 1 ----(1, -2) 0 -1 There would be "axis" numbers on the edge of a "map". Every cell in the map would display the location in the map as (row, col), like "(1,-2)" in the example above. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! Find Closest Coordinate Match | Excel Discussion (Misc queries) | |||
Polar to rectangular coordinate conversion | Excel Discussion (Misc queries) | |||
Labeled Coordinate Plots | Excel Discussion (Misc queries) | |||
Identify Label €” More than one cell with label | Excel Discussion (Misc queries) | |||
Creating an x,y coordinate chart | Charts and Charting in Excel |