Row number in another cell (in row and column)

M

MikeB

I have a grid of names. I'd like to assign a number to each name,
simply to make it easy to find each name in the row and in the
column. To minimize confusion, I'd also like to have this number
being the same number as the row that the name appears in.

If that is unclear, perhaps a picture might explain what I'm trying to
do. http://i37.tinypic.com/eah509.jpg

The red ovals encircle the fields I'd like to devise a formula for.
The red numbers is what, ideally, I'd like to appear in those cells.

Can anyone suggest a formula for the horizontal and vertical cells
that might do this?

Thanks.
 
R

Rick Rothstein

I don't see any picture when I click that link... the status bar says
"Done", but no picture is displayed.
 
D

Don Guillett

Should be pretty easy. for the rows =row() dragged down. For the columns
=column(a1) drag across
 
M

MikeB

I don't see any picture when I click that link... the status bar says
"Done", but no picture is displayed.
Click to expand...

I'm sorry about that. I don't know why, it displays fine in my
browser.
 
M

MikeB

Should be pretty easy. for the rows =row() dragged down. For the columns
=column(a1) drag across
Click to expand...

Don, thanks!. It was actually Column(C1) and drag across that did the
trick, but you got me pointed the right way.
 

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

Pull a column header from a row of numbers 1
lookup and return column number 2
Excel Help to copy information from one row at a time to another sheet 1
Looking for the value that indicates last row number that has filled cells 3
Find 2 values & return row number 1
Find column number 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2

Top