What function can I use?

  • Thread starter Thread starter Louie Warren
  • Start date Start date
L

Louie Warren

I have the following table

C1 C2 C3 C4 C5 C6
R1: - X - - X -
R2: X - - X - -
R3: - - X - - X
Total: 2 1 3 2 1 3

Basically, the default value in each cell is - and when I
enter an X, I want the total to tell me which position it
resides in. The values will be 1, 2, and 3. What can I
use to do this automagically? It is beyond my feeble mind.

Thanx!
 
Hi
enter the following in A4
=IF(ISNA(MATCH("X",A1:A3,0),"",MATCH("X",A1:A3,0))
and copy this to the right
 
1. Missed a )

=IF(ISNA(MATCH("X",A1:A3,0)),"",MATCH("X",A1:A3,0))

2. Ok, what if I have values A, B, C, D, E, F, G... I can
enter one of these in only one cell in the column. When I
do, I want the position of that value in the row (1, 2, or
3)... How can I do that?

Thanx!
 
Hi
try the following array formula for this (entered with
CTRL+SHIFT+ENTER):

=IF(ISNA(MATCH(1,(CODE(A1:A3)>=65)*(CODE(A1:A3)<=71),0)),"",MATCH(1,(CO
DE(A1:A3)>=65)*(CODE(A1:A3)<=71),0))

tests charatcers A-G
 
That gives me #VALUE! What have I done wrong?

-----Original Message-----
Hi
try the following array formula for this (entered with
CTRL+SHIFT+ENTER):

=IF(ISNA(MATCH(1,(CODE(A1:A3)>=65)*(CODE(A1:A3) <=71),0)),"",MATCH(1,(CO
DE(A1:A3)>=65)*(CODE(A1:A3)<=71),0))

tests charatcers A-G

--
Regards
Frank Kabel
Frankfurt, Germany




.
Click to expand...
 
That gives me #VALUE! as a result.

-----Original Message-----
Hi
try the following array formula for this (entered with
CTRL+SHIFT+ENTER):

=IF(ISNA(MATCH(1,(CODE(A1:A3)>=65)*(CODE(A1:A3) <=71),0)),"",MATCH(1,(CO
DE(A1:A3)>=65)*(CODE(A1:A3)<=71),0))

tests charatcers A-G

--
Regards
Frank Kabel
Frankfurt, Germany




.
Click to expand...
 
Hi
you have to enter this as array formula. that is hit CTRL+SHIFT+ENTER
instead onyl a single ENTER
 
Thanx! That did it. One of these days I'll read the
ENTIRE post and quit being a dumbass.
 
Back
Top