X EQUALS A NUMBER

C

Carmine JP

I would like to place an x in a cell and it repesents a number:

For example:

Always Frequently Occationally Seldom Never
=1 =2 =3 =4 =5

Only one x per row.

There are several rows with questions and each answer needs to be
represented with an X and the X needs to have a value.
 
R

RagDyer

Do you want an individual numerical return per question (row)?

With questions in Column A,
Headers in B1 to F1,
Enter this formula in G2:

=MATCH("x",B2:F2,0)

And copy down as needed.

Will return a number in Column G per question.

If I misunderstood, post back with more info.
 
C

Carmine JP

(Col 1) (Col 2) (Col 3) (Col 4) (Col 5)
(Row 1) Always Frequently Occationally Seldom Never
(Row 2) =1 =2 =3 =4 =5

You place one X in row 1 which applies to the question the numbers would
represent a score.
 
R

RagDyer

Can we call Col 1 Column A,
and Col 2 Column B, ... etc.?

NOW, where do you want to see the number displayed that represents the
placement (location) of the "X"?

Do you want it displayed in Row 2, directly under the "X"?

And if so, where will the next "X" be placed?
In Row 3, with the number displayed in Row 4?
 
Top