Row number in another cell (in row and column)

  • Thread starter Thread starter MikeB
  • Start date Start date
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.
 
I don't see any picture when I click that link... the status bar says
"Done", but no picture is displayed.
 
Should be pretty easy. for the rows =row() dragged down. For the columns
=column(a1) drag across
 
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.
 
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.
 
Back
Top