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

Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 2
Looking for the value that indicates last row number that has filled cells 5
how to return "summary" of all non-blank cells plus their headers 10
After I reset my Games they get scambled. Conditional Formatting orMacro messed up somewhere 1
Insert Index into a Table 1
Count Non-Empty Cells In Each Row 0
A way to increase a number in a cell by using the + key 3

Top