How to get the coordinate of an worksheet entry

J

joecoolman

Joined
Mar 6, 2008
Messages
1
Reaction score
0
Hello There.

I am more or less new in working with functions and worksheet, be patient.

It seems to be incredible that there no exists such a custom function in Excel
which gives the "coordinate" of an entry, example:

A B C
-----------------------------
1| | | |
2| | f| |
3| | | |

COORD(f;A1:C3) = B2 !!!

It seems to me very difficult to combine some functions in Excel to do the same as my imaginary function COORD.
Can anyone figure this out ? I am using Office XP.

Thanks buddy.
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to fill in map coordinates for addresses 2
Testing if a point is falling within the bounds of intersecting cu 6
Function in Excel to count and list number of entries of text valuesin a row. 2
Time when an entry was made 2
How do I get Excel to display a table on a different worksheet? 7
how to transform numbers to excell worksheet coordinates 2
count no. of times a character occurs in a cell 2
How can I use a worksheet to plot polar coordinates? 1

Back
Top